Showing posts with label timeand. Show all posts
Showing posts with label timeand. Show all posts

Sunday, February 12, 2012

Can't use DAC in SQL2K5.

SQL2K5
No SP.
Im trying to test out Dedicated Administrator Connection for my first time
and getting an error message:
____________________________
Cannot connect to admin:Server\InstanceName.
Additional information:
DAC's are not supported. (ObjectExplorer)
_________________________
The Browser service is running.
Any ideas?
TIA, ChrisRHi ChrisR
Is it a SQL Express instance?
From BOL: To conserve resources, SQL Server 2005 Express Edition does not
listen on the DAC port unless started with a trace flag 7806.
Is it a remote instance?
DAC must be enabled for remote connections from the Configuration
Manager.
HTH
Kalen Delaney, SQL Server MVP
"ChrisR" <ChrisR@.noEmail.com> wrote in message
news:OLSsHeBjGHA.4748@.TK2MSFTNGP04.phx.gbl...
> SQL2K5
> No SP.
> Im trying to test out Dedicated Administrator Connection for my first time
> and getting an error message:
>
> ____________________________
> Cannot connect to admin:Server\InstanceName.
> Additional information:
> DAC's are not supported. (ObjectExplorer)
> _________________________
> The Browser service is running.
> Any ideas?
> TIA, ChrisR
>|||No ma'am.
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Also, it is on my local workstation.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:e0gkxtCjGHA.4512@.TK2MSFTNGP04.phx.gbl...
> Hi ChrisR
> Is it a SQL Express instance?
> From BOL: To conserve resources, SQL Server 2005 Express Edition does
not
> listen on the DAC port unless started with a trace flag 7806.
> Is it a remote instance?
> DAC must be enabled for remote connections from the Configuration
> Manager.
> --
> HTH
> Kalen Delaney, SQL Server MVP
>
> "ChrisR" <ChrisR@.noEmail.com> wrote in message
> news:OLSsHeBjGHA.4748@.TK2MSFTNGP04.phx.gbl...
time[vbcol=seagreen]
>|||Ok, I duplicated this. You can't use DAC to connect to the Object Explorer,
only when opening a query window.
HTH
Kalen Delaney, SQL Server MVP
"ChrisR" <ChrisR@.noEmail.com> wrote in message
news:%231B2YEEjGHA.1264@.TK2MSFTNGP05.phx.gbl...
> No ma'am.
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
> Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack
> 4)
> Also, it is on my local workstation.
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:e0gkxtCjGHA.4512@.TK2MSFTNGP04.phx.gbl...
> not
> time
>|||To continue, your initial connection can't be DAC so first open the Mgmt
Studio without DAC, and then open a query window with a DAC.
HTH
Kalen Delaney, SQL Server MVP
"ChrisR" <ChrisR@.noEmail.com> wrote in message
news:%231B2YEEjGHA.1264@.TK2MSFTNGP05.phx.gbl...
> No ma'am.
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
> Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack
> 4)
> Also, it is on my local workstation.
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:e0gkxtCjGHA.4512@.TK2MSFTNGP04.phx.gbl...
> not
> time
>|||Perfect, thanks alot Kalen!
Have a great weekend!
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uzgZg$EjGHA.4884@.TK2MSFTNGP03.phx.gbl...
> To continue, your initial connection can't be DAC so first open the Mgmt
> Studio without DAC, and then open a query window with a DAC.
> --
> HTH
> Kalen Delaney, SQL Server MVP
>
> "ChrisR" <ChrisR@.noEmail.com> wrote in message
> news:%231B2YEEjGHA.1264@.TK2MSFTNGP05.phx.gbl...
Pack[vbcol=seagreen]
does[vbcol=seagreen]
>