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