Export (0) Print
Expand All
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.

Community Additions

ADD
Show:
© 2014 Microsoft