What port do you need to open on your server fir

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

(Continued from previous question...)

What port do you need to open on your server firewall to enable named pipes connections?

Answer
Port 445

Explanation
Named pipes communicates across TCP port 445.

(Continued on next question...)

Other Job Interview Questions

• How many users can be added to an application role in SQL Server 2005?
• No column permissions are assigned. What should you do?
• 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?
• To recover an instance of Notification Services in 2005 on another server, what information would you need?
• What is row versioning in SQL Server 2005?
• What is the default type of XML data if you do not specify an arguement?
• What is a dialog conversation in the SQL Server 2005 Service Broker.
• How many connections are available in SQL Server MSDE 2000?
• Which of the following services is instance-aware?
• Where can you view the list of server-scoped DDL triggers?
• More...