Remote Admin Connections

SQL Server supports a dedicated administrator connection (DAC) to allow an administrator to connect to the database engine on a different port (default 1434) even when normal connections on the regular port (default 1433) would be impossible (such as if the server is locked or running in an abnormal state). By default, SQL Server will only accept administrator connections on the DAC port on the localhost, but turning on this setting will allow remote connections too.

Suggested Action

šŸ’” Select 'Suggested Script' for an automatically generated script.

Enable the remote admin connections setting.

How to Enable Remote Admin Connections for SQL Server

EXEC sys.sp_configure N'remote admin connections', N'1'
GO  
RECONFIGURE;  
GO  

Further Reading

Remote Admin Connections | Microsoft Docs