:::: MENU ::::

DAC in SQL Server 2005 Express Edition

  • Jan 07 / 2010
  • 0
DBA Interview questions, dbDigger

DAC in SQL Server 2005 Express Edition

By default does SQL Server 2005 Express allow Dedicated Administrator Connections (DAC)?

Answer: Yes, if started with trace flag 7806

Explanation: SQL Server 2005 Express Edition does not listen on the DAC port by default. If it is started with trace flag 7806, then DAC connections can be made.

Question:

On which port can you make a Dedicated Administrator Connection (DAC)?

Answer: Dynamically assigned

Explanation: The DAC port is dynamically assigned when the instance starts and listed in the SQL Server error log. By default it tries for 1434, but it is possible that this port is already in use. The message will be something like:

Dedicated admin connection support was established for listening locally on port 1977.

Note: The question of day is taken from SqlServerCentral.com. I want to compile selected QOD to share.

Consult us to explore the Databases. Contact us