Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite

Is it possible to connect to the DAC using SSMS? If I understand correctly, it should be possible by using "admin:" prefix before the server name, but I receive the following message:

Dedicated administrator connections are not supported via SSMS as it establishes multiple connections by design. (Microsoft.SqlServer.Management.SqlStudio.Explorer)

share|improve this question
This? mssqlforum.wordpress.com/2010/12/09/… – Phil May 16 '12 at 14:35
Or maybe this: "By default, the connection is only allowed from a client running on the server. Network connections are not permitted unless they are configured by using the sp_configure stored procedure with the remote admin connections option." – swasheck May 16 '12 at 14:36

1 Answer

up vote 4 down vote accepted

You cannot connect the object explorer with the DAC. You need to use a single query window, and you can right-click on it to Connect/Change Connection.

The nature of object explorer is that it uses multiple connections, which is not allowed with the DAC.

Another piece with the DAC, out of the box it only allows local connections (due to security reasons). If you want to be able to connect to the DAC remotely, you need to configure it accordingly:

exec sp_configure 'remote admin connections', 1
go
reconfigure
go
share|improve this answer
Also, if you have level 20 notifications set up, you may want to disable IntelliSense in the query window before connecting. – Jon Seigel May 17 '12 at 1:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.