Getting a Dedicated Admin Connection

Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way.

I tested this on a SQL Server 2008 instance, having a normal connection, as seen in the lower status bar:

admin_connection2

Right click in the query window, and select “Change Connection”. In the dialog, not add “Admin:” before the server name, as shown below.

admin_connection

When you connect, you’ll have an admin connection, which you can see in the status bar.

admin_connection1 

Pretty cool.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.