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

šŸ’” Aireforge Advisor can automatically generate a script for this.

Enable the remote admin connections setting.

How to Enable Dedicated Administrator Connection for SQL Server

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

Further Reading

Remote Admin Connections | Microsoft Docs