Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections.

DAC-

The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and running simple queries in the event of significant performance issues. This tells SQL Server to set aside a thread for processing your queries in the event of an emergency.

How to enable DAC for remote connections-

Step 1- To begin, open SSMS and connect to the server.

Fig. 1

Step 2- To verify whether the DAC is enabled or not, open a new query window and enter the syntax sp configure.

Fig.2

Step 3- You must first write the syntax sp configure ‘remote admin connections’,1; reconfigure with override to activate the DAC.

Fig.3

Step 4- You must check that the DAC connection is enabled once more. sp configure is the syntax to use.

Fig.4

Fig.5