DBA > Job Interview Questions > Microsoft SQL Server FAQs

In a new default SQL Server 2005 installation, w

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

In a new default SQL Server 2005 installation, what is the status of the dedicated administrator connection?

Answer
Enabled for local connections only.
Explanation
The dedicated adminstrator connection is enabled for local connections only by default.

(Continued on next question...)

Other Job Interview Questions