Home > SQL General > Dedicated administrator connections are not supported. (Microsoft.SqlServer.Management.SqlStudio.Explorer)

Dedicated administrator connections are not supported. (Microsoft.SqlServer.Management.SqlStudio.Explorer)

December 9, 2010

When trying to open DAC using SSMS you will get Dedicated administrator connections are not supported. (Microsoft.SqlServer.Management.SqlStudio.Explorer). if you get this error message then you are trying to open DAC connection using the Object explorer. Only one DAC connection can be opened so we will not be able to use object explorer to open DAC. 

There are two ways to open DAC connection

1.SSMS>New>Database Engine Query > ADMIN:Servername (on the server name)

2.SQLCMD -S Servername -E -A

About these ads
Categories: SQL General
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: