| title | remote admin connections Server Configuration Option | Microsoft Docs | |||||
|---|---|---|---|---|---|---|
| description | Learn how applications on remote computers can use the DAC. See how to use the "remote admin connections" option with "sp_configure" to turn on this capability. | |||||
| ms.custom | ||||||
| ms.date | 03/02/2017 | |||||
| ms.prod | sql | |||||
| ms.prod_service | high-availability | |||||
| ms.reviewer | ||||||
| ms.technology | configuration | |||||
| ms.topic | conceptual | |||||
| helpviewer_keywords |
|
|||||
| ms.assetid | bf32b60a-7a48-401f-b6be-b5e2e46c413f | |||||
| author | markingmyname | |||||
| ms.author | maghan |
[!INCLUDE SQL Server]
[!INCLUDEssNoVersion] provides a dedicated administrator connection (DAC). The DAC lets an administrator access a running server to execute diagnostic functions or [!INCLUDEtsql] statements, or to troubleshoot problems on the server, even when the server is locked or running in an abnormal state and not responding to a [!INCLUDEssDEnoversion] connection. By default, the DAC is only available from a client on the server. To enable client applications on remote computers to use the DAC, use the remote admin connections option of sp_configure.
By default, the DAC only listens on the loop-back IP address (127.0.0.1), port 1434. If TCP port 1434 is not available, a TCP port is dynamically assigned when the [!INCLUDEssDE] starts up. When more than one instance of [!INCLUDEssNoVersion] is installed on a computer, check the error log for the TCP port number.
The following table lists the possible values for the remote admin connections option.
| Value | Description |
|---|---|
| 0 | Indicates only local connections are allowed by using the DAC. |
| 1 | Indicates remote connections are allowed by using the DAC. |
The following example enables the DAC from a remote computer.
sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO