SQL Server 2005 Dedicated Administrator Connection


Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client connections. The DAC is available through the sqlcmd utility and SQL Server Management Studio. The connection is only allowed from a client running on the server. No network connections are permitted.

To connect to a server using the DAC

1.      In SQL Server Management Studio, with no other DACs open, on the toolbar, click Database Engine Query.
2.      In the Connect to Database Engine dialog box, in the Server name box, type ADMIN: followed by the name of the server instance. For example, to connect to a server instance named ACCT\PAYABLE, type ADMIN:ACCT\PAYABLE.
3.      Complete the Authentication section, providing credentials for a member of the sysadmin group, and then click Connect.

The connection is made.      If the DAC is already in use, the connection will fail with an error indicating it cannot connect.

By default the DAC is only available from a client on the server.  To enable remote clients to utilize the DAC an option needs to be set which can be done using sp_configure

•sp_configure ‘remote admin connections’, 1;

or by using the SQL Server Surface Area Configuration.  To do this:

•launch the SQL Server Surface Area Configuration.tool which can be found under SQL Server 2005 Configuration Tools in the SQL Server 2005 menus

•select “Surface Configuration Area for Features”.

•check the box for “Enable remote DAC”

•select “Apply”

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: