Surface Area Configuration for Features (DAC) - Database Engine

SQL Server Setup

previous page next page

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.

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.

Change History

Release History

5 December 2005

New content:
  • Added clarification about using this option with cluster configurations.

See Also

previous page start next page