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
May be an unrespectable answer.
DAC is enabled and still the problem persists.
Thank you.
"Theo Verweij" wrote:

> Maybe a stupid question, but do you have DAC enabled on this server (it
> is disabled by default)?
> Bishoy wrote:
>
|||If this is remote, you need to make sure to enable remote
admin connections with sp_configure.
But the error indicates you're running into something else.
The DAC is only supported for a query window, it's not
supported with Object Explorer. If trying to connect with a
DAC in SSMS, try opening a regular connection first and then
open a query window with a DAC.
-Sue
On Sun, 5 Nov 2006 10:44:01 -0800, Bishoy
<Bishoy@.discussions.microsoft.com> wrote:

>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
|||Dear Tibor and Sue,
You are just correct.
Actually it works with new query only.
Thank you alot.
Bishoy
|||Hi Bishoy
The error message is very specific. It says you cannot open a DAC connection
to Object Explorer. That is the default when you try to open Management
Studio.
You need to open Management Studio, and then you can open a query window
with the DAC.
Alternatively, you can configure Management Studio to open a Query Window
instead of explorer on startup.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> 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

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?

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.
BishoyMaybe a stupid question, but do you have DAC enabled on this server (it
is disabled by default)?
Bishoy wrote:
> 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|||May be an unrespectable answer.
DAC is enabled and still the problem persists.
Thank you.
"Theo Verweij" wrote:

> Maybe a stupid question, but do you have DAC enabled on this server (it
> is disabled by default)?
> Bishoy wrote:
>|||> Dedicated administrator connections are not supported. (ObjectExplorer)
Are you trying to open a query window or Object Explorer through the DAC? Yo
u can only have one
connection using the DAC, and Object Explorer can not use the DAC.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> 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|||If this is remote, you need to make sure to enable remote
admin connections with sp_configure.
But the error indicates you're running into something else.
The DAC is only supported for a query window, it's not
supported with Object Explorer. If trying to connect with a
DAC in SSMS, try opening a regular connection first and then
open a query window with a DAC.
-Sue
On Sun, 5 Nov 2006 10:44:01 -0800, Bishoy
<Bishoy@.discussions.microsoft.com> wrote:

>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|||Dear Tibor and Sue,
You are just correct.
Actually it works with new query only.
Thank you alot.
Bishoy|||I apologize.
Bishoy wrote:[vbcol=seagreen]
> May be an unrespectable answer.
> DAC is enabled and still the problem persists.
> Thank you.
> "Theo Verweij" wrote:
>|||Hi Bishoy
The error message is very specific. It says you cannot open a DAC connection
to Object Explorer. That is the default when you try to open Management
Studio.
You need to open Management Studio, and then you can open a query window
with the DAC.
Alternatively, you can configure Management Studio to open a Query Window
instead of explorer on startup.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> 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

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.
BishoyMaybe a stupid question, but do you have DAC enabled on this server (it
is disabled by default)?
Bishoy wrote:
> 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|||May be an unrespectable answer.
DAC is enabled and still the problem persists.
Thank you.
"Theo Verweij" wrote:
> Maybe a stupid question, but do you have DAC enabled on this server (it
> is disabled by default)?
> Bishoy wrote:
> > 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
>|||> Dedicated administrator connections are not supported. (ObjectExplorer)
Are you trying to open a query window or Object Explorer through the DAC? You can only have one
connection using the DAC, and Object Explorer can not use the DAC.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> 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|||If this is remote, you need to make sure to enable remote
admin connections with sp_configure.
But the error indicates you're running into something else.
The DAC is only supported for a query window, it's not
supported with Object Explorer. If trying to connect with a
DAC in SSMS, try opening a regular connection first and then
open a query window with a DAC.
-Sue
On Sun, 5 Nov 2006 10:44:01 -0800, Bishoy
<Bishoy@.discussions.microsoft.com> wrote:
>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|||Dear Tibor and Sue,
You are just correct.
Actually it works with new query only.
Thank you alot.
Bishoy|||I apologize.
Bishoy wrote:
> May be an unrespectable answer.
> DAC is enabled and still the problem persists.
> Thank you.
> "Theo Verweij" wrote:
>> Maybe a stupid question, but do you have DAC enabled on this server (it
>> is disabled by default)?
>> Bishoy wrote:
>> 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
The error message is very specific. It says you cannot open a DAC connection
to Object Explorer. That is the default when you try to open Management
Studio.
You need to open Management Studio, and then you can open a query window
with the DAC.
Alternatively, you can configure Management Studio to open a Query Window
instead of explorer on startup.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> 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