DBA > Job Interview Questions > Microsoft SQL Server FAQs

You want to be sure your database server if prop

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

(Continued from previous question...)

You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?

Answer
1433 and a specific port after configuring the named instance to use that specific port
Explanation
Named instances must be configured to use a specific port and that port then opened in the firewall.

(Continued on next question...)

Other Job Interview Questions