SQL Server Health Check

SQL Server Remote Dedicated Admin Connection (DAC)

Updated October 29, 20252 min read

Why enable the Dedicated Admin Connection. Ploom slips through a small red side door beside a big jammed main gate.

What is the Dedicated Admin Connection (DAC) in SQL Server?

It’s a diagnostic connection for a database administrator to access SQL Server.

The DAC can make remote troubleshooting easier when SQL Server is unresponsive.

When SQL Server is experiencing issues, the DAC can be used to log in to fix problems and avoid downtime.

How to identify the issue?

DAC is only allowed from a client running on the server by default.

It’s a best practice to enable network connections to use it from a remote machine.

You can check if the feature is enabled by following the steps below:

  1. Using SQL Server Management Studio (SSMS), connect to the SQL Server instance and then right-click the Server and select Facets as shown below.
Figure 1 - Facets (SSMS)
Figure 1 - Facets (SSMS)
  1. In the View Facets window, you need to choose the Facet as Surface Area Configuration and then check for RemoteDacEnabled.
Figure 2 - SQL Server RemoteDacEnabled Property
Figure 2 - SQL Server RemoteDacEnabled property

How do I enable DAC? How to fix it?

You can enable it using the interface above, just changing the property to ENABLED.

Another way is to implement the change by running the following script:

T-SQL
sp_configure ‘show advanced options’
	,1 GO

RECONFIGURE
WITH override GO sp_configure ‘remote admin connections’
	,1 GO

RECONFIGURE
WITH override

Notes:

  • Only members of the SQL Server sysadmin role can connect using the DAC, and only one connection can be made at a time.
  • Make sure to get firewall ports opened. This will probably be port 1434, but that will vary depending on your installation.

More information

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜