Question:
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.
Thursday, January 7, 2010
Subscribe to:
Post Comments (Atom)


0 comments:
Post a Comment
Express your views about this post