Remote Dedicated Admin Connection
Revision as of 18:16, 10 October 2023 by User (talk | contribs) (Created page with "<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, how...")
WHAT IS the DAC?
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.
WHAT’s THE DIFFERENCE BETWEEN the DAC AND REMOTE DAC?
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