Enable Dedicated Administrator Connection

I installed a new SQL Server, but it cannot connect with the Dedicated Administrator Connection?

more ▼

asked Oct 21, 2009 at 01:27 PM in Default

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 78 79 82

(comments are locked)
10|1200 characters needed characters left

2 answers: sort oldest

Are you attempting to connect from the local server, or a remote machine? Using SQLCMD or SSMS?

Here are a few things to keep in mind when working with the Dedicated Administrator Connection (DAC):

Verify the account you are connecting with is a SysAdmin on the SQL Server. The DAC is only available to members of the SysAdmin server role.

By default, the DAC is only available on the local server. If you are trying to connect from a remote machine, you will need to enable network connections:

EXEC sp_configure 'show advanced options', '1'

EXEC sp_configure 'remote admin connections', '1'

If you are using SQLCMD, be sure to use the -A switch to access a DAC. If you are using SSMS, be sure to prepend "ADMIN:" to your server name.

Here is a brief overview from MS

more ▼

answered Oct 21, 2009 at 01:52 PM

KenJ gravatar image

20.3k 1 4 12

(comments are locked)
10|1200 characters needed characters left

See the following links for information on using the dedicated administrator connection:



more ▼

answered Oct 21, 2009 at 01:50 PM

NYSystemsAnalyst gravatar image

312 5 5 6

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 21, 2009 at 01:27 PM

Seen: 3403 times

Last Updated: Oct 21, 2009 at 01:27 PM