Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Surface Area Configuration for Features (DAC) - Database Engine

SQL Server 2005

Updated: 5 December 2005

The dedicated administrator connection (DAC) allows an administrator to connect to a server to execute diagnostic functions or Transact-SQL statements. The DAC can be used when the Database Engine will not respond to regular connections. By default, this feature is only enabled for a local connection. Enable this option to use the DAC from a remote computer. On cluster configurations, you must enable this option to connect with the DAC.

Enable remote DAC

If checked, the DAC is enabled from remote computers.

For more information about the DAC, see Using a Dedicated Administrator Connection in SQL Server Books Online.

For more information about configuring server options, see sp_configure (Transact-SQL) in SQL Server Books Online.

Release History

5 December 2005

New content:
  • Added clarification about using this option with cluster configurations.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft