DBA > Job Interview Questions > Microsoft SQL Server Database Administrator Exam

What is the difference between a Default Instanc

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

(Continued from previous question...)

What is the difference between a Default Instance and a Named Instance of MS SQL Server?

A MS SQL Server can be installed as a Default Instance or a Named Instance.
A Default Instance can be reached by client applications using the server name like UAT-SERVER.
A Named Instance can be reached by client applications using the server name plus the instance name like UAT-SERVER\SQL2010

(Continued on next question...)

Other Job Interview Questions