Surface Area Configuration for Features (DAC) - Database Engine

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.

Options

• 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.

See Also

Concepts

Surface Area Configuration for Features
Surface Area Configuration for Services and Connections

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
5 December 2005	New content: Added clarification about using this option with cluster configurations.