2006/08/29

'Dedicated administrator connections are not supported. (ObjectExplorer)' error

Dedicated Administrator Connection (DAC) is a new feature of SQL Server 2005; it is a special diagnostic connection for administrators that can be used to connect to a server when standard connections are not possible.

If you are trying to connect to a server using the DAC with SQL Server Management Studio and you keep getting the following error:

Dedicated administrator connections are not supported. (ObjectExplorer)

it means that you are trying to connect Object Explorer using the DAC.

Object Explorer cannot connect using the DAC; only Query Window can. That means that you cannot press the New Query button; you have to use the Database Engine Query button.

11 comments:

  1. thanks .. saved me a couple of hours !

    ReplyDelete
  2. This information is eye-opener.

    Thanks,

    Pathak.

    ReplyDelete
  3. Thanks you really saved me.

    ReplyDelete
  4. Thanks... had been figuring out where the database engine query button is. I finally found through your article.

    ReplyDelete
  5. thanks :) it's better than msdn ^)

    ReplyDelete
  6. Thanks. Exactly what I've needed

    ReplyDelete
  7. Kingston Xavier8/26/2012 9:17 PM

    Thanks, i was struggling to connect DAC through object explorer, appreciate your article.

    ReplyDelete
  8. Good one..its helped me.

    ReplyDelete
  9. good one :), thanks!

    ReplyDelete