Editing Remote Dedicated Admin Connection

<strong>WHAT IS the DAC?</strong>

DAC is an acronym for Dedicated Admin Connection: a tool for connecting to SQL Server so you can run basic troubleshooting queries in cases of serious performance problems.

<strong>WHAT’s THE DIFFERENCE BETWEEN the DAC AND REMOTE DAC?</strong>

DAC and Remote DAC are the same feature — the difference is in where you connect to it from. The DAC is already enabled for local connections. In order to use that from a remote machine, however, we need to enable remote connections.

In either case, only sysadmins can use it, and only one connection can be made at a time.


Return to [[SQL Server]]