On which port does the default instance of SQL S

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

(Continued from previous question...)

On which port does the default instance of SQL Server 2005 Analysis Services listen to by default?

Answer: 2383

Explanation: The default port for SQL Server 2005 Analysis Services is 2383. For SQL Server 2000, it is 2725. 2382 is the redirector for other instances of SQL Server 2005 Analysis Services.

(Continued on next question...)

Other Job Interview Questions

• What does the SQL Writer service do?
• In SQL Server 2005, if you initialize a subscription using FTP, how is the password sent?
• What feature of SQL Server 2005 would help you get the snapshot transferred?
• What does this return? select (1324 & 1024)
• What is a dialog conversation in the SQL Server 2005 Service Broker.
• When you use the sp_xml_preparedocument stored procedure in SQL Server 2000, what is returned?
• What is an index? What types of indexes are available in SQL Server 2000?
• What will occur with the following code in SQL Server 2005 if executed by Alice?
• Which framework would you use to manage this database programatically?
• Which key does the OPEN MASTER KEY statement open?
• More...