x

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 77 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'
RECONFIGURE WITH override

EXEC sp_configure 'remote admin connections', '1'
RECONFIGURE WITH override

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

KenJ
20.1k 1 3 12

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

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

http://msdn.microsoft.com/en-us/library/ms189595.aspx

http://www.mssqltips.com/tip.asp?tip=1005

more ▼

answered Oct 21, 2009 at 01:50 PM

NYSystemsAnalyst gravatar image

NYSystemsAnalyst
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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x344
x162
x2

asked: Oct 21, 2009 at 01:27 PM

Seen: 3359 times

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