Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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