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