remote admin connections Option

Microsoft SQL Server 2005 provides a dedicated administrator connection (DAC). The DAC lets an administrator access a running server in order to execute diagnostic functions or Transact-SQL statements, or troubleshoot problems on the server, even when the server is locked or running in an abnormal state and not responding to a Database Engine connection. By default, the DAC is only available from a client on the server. Use the remote admin connections option of sp_configure to allow client applications on remote computers to use the DAC.

By default the DAC only listens on the loop-back IP address (127.0.0.1), port 1434.

Possible values of the remote admin connections setting:

  • 0 - indicates only local connections are allowed using the DAC
  • 1 - indicates remote connections are allowed using the DAC

Example

The following code enables the DAC from a remote computer.

sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO

See Also

Tasks

How to: Use the Dedicated Administrator Connection with SQL Server Management Studio

Concepts

Using a Dedicated Administrator Connection

Help and Information

Getting SQL Server 2005 Assistance