remote admin connections
Type: Basic
Default value: 0
Microsoft SQL Server 2012 provides a dedicated administrator connection (DAC). The DAC lets an administrator access a running server to be able to execute diagnostic functions or T-SQL statements, or troubleshoot problems on the server, even when the server is locked or running in an abnormal state and not responding to any other type of user connection. By default, the DAC is available only from a client on the server. But if you set the Remote Admin connections option to 1, the DAC is available from a remote connection as well. By default, the DAC listens only on the loopback IP address (127.0.0.1), port 1434.
The following is an example of this option:
exec ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
