Cannot connect to admin:ServerName

Hi All,

When I try to connect to SQL Server 2005 by using Dedicated administrator connections by admin:ServerName.

I encounter this error:
Cannot connect to admin:ServerName
Dedicated administrator connections are not supported. (ObjectExplorer)

N.B.:
I use SQL authentication to connect.
SQL authentication is working without the "admin:" prefix.

Thank you.
Bishoy

Hi Bishoy,

Make sure you have enabled DAC in the SQL Surface Area Configuration under features. It is disabled by default.

Cheers,

Rob

|||DAC for sqlexpress is disabled by default. Add trace 7806 as part of the startup trace for sqlserver. Restart the service to the effect. Don't forget to enable/start sqlbrowser service too.

See the following kb for more info:
http://msdn2.microsoft.com/en-us/library/ms189595.aspx|||

Robert Varga wrote:

Hi Bishoy,

Make sure you have enabled DAC in the SQL Surface Area Configuration under features. It is disabled by default.

Cheers,

Rob

Thanks for the pointer, no wonder it didn't work when I tried.

Question is, I have enabled DAC on 3 SQL servers, but still cannot connect into them with ADMIN:SERVERNAME

Error is "Dedicated administrator connections are not supported."

Do I need to restart the SQL Server?