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.

Posted by
Labels: ,

11 comments:

  1. Anonymous3/24/2008 12:45 AM

    thanks .. saved me a couple of hours !

    ReplyDelete
  2. Unknown5/06/2008 9:59 PM

    This information is eye-opener.

    Thanks,

    Pathak.

    ReplyDelete
  3. Anonymous7/30/2008 9:18 AM

    Thanks you really saved me.

    ReplyDelete
  4. Keith Hutchison1/12/2010 3:31 AM

    Many thanks

    Keith Hutchison

    ReplyDelete
  5. Anonymous3/10/2011 9:11 PM

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

    ReplyDelete
  6. Anonymous10/18/2011 1:16 AM

    thanks :) it's better than msdn ^)

    ReplyDelete
  7. razvantim6/11/2012 11:01 PM

    Thanks. Exactly what I've needed

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

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

    ReplyDelete
  9. Damodar10/14/2012 7:17 AM

    Excellent one. Thanks

    ReplyDelete
  10. cm1/13/2014 10:03 PM

    Good one..its helped me.

    ReplyDelete
  11. Anonymous7/31/2014 12:51 PM

    good one :), thanks!

    ReplyDelete

Subscribe to: Post Comments (Atom)