Remote Dedicated Admin Connection: Difference between revisions
Jump to navigation
Jump to search
(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...") |
No edit summary |
||
| Line 8: | Line 8: | ||
In either case, only sysadmins can use it, and only one connection can be made at a time. | In either case, only sysadmins can use it, and only one connection can be made at a time. | ||
<strong>How to enable Remote DAC</strong> | |||
<pre>EXEC sp_configure 'remote admin connections', 1; | |||
GO | |||
RECONFIGURE | |||
GO</pre> | |||
<strong>How to connect to the DAC</strong> | |||
From an SSRS | |||
[[Image:Connect_to_dac.png]] | |||
Return to [[SQL Server]] | Return to [[SQL Server]] | ||
Revision as of 18:35, 10 October 2023
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.
How to enable Remote DAC
EXEC sp_configure 'remote admin connections', 1; GO RECONFIGURE GO
How to connect to the DAC
From an SSRS
Return to SQL Server