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.
💡 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
Remote Admin Connections | Microsoft Docs