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:


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


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


Pretty cool.

About way0utwest

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