What information do you need to identify a remot

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

(Continued from previous question...)

What information do you need to identify a remote MS SQL Server to make a connection request?

To make a connection request for a remote MS SQL Server, you need to identify it with 2 pieces of information:
"Server name" and "Instance name".

(Continued on next question...)

Other Job Interview Questions

• What is the different between concurrent connections and concurrent user logins?
• What is a Stored Procedure in MS SQL Server?
• On MS SQL Server management tool, how would you find what actions you can perform for a particular object?
• What is the difference between a "User DSN" and a "System DSN" ODBC connection?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• What does Default Object refers to in MS SQL Server?
• What does Field refers to in MS SQL Server?
• What is the "master" database? Can I delete it to save disk space?
• What information do you need to identify a remote MS SQL Server to make a connection request?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• More...