What could be the problem if you know the servic

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

(Continued from previous question...)

What could be the problem if you know the service is working properly?

You have tightly secured access to your SQL Server 2005 server by placing it behind a firewall and limited ports 1433 to those clients that need to directly access the SQL Server. One of your developers complains about connecting to the Integration Services esrvice on your server. What could be the problem if you know the service is working properly?


Answer
The firewall needs to allow port 135 through for Integration Services

Explanation
Integration Services requires access to both DCOM and port 135. You need to open this port to allow the developer to communicate with SSIS.

(Continued on next question...)

Other Job Interview Questions

• What does the CREATE SERVICE statement do in SQL Server 2005?
• You want to release some memory and reduce SQL Server to 3GB or RAM. How can you do this?
• Which protocols support Kerberos authentication on SQL Server 2005?
• What's an allocation unit?
• You are implementing replication across the Internet for a large bank that wishes to move up to date pricing information...
• What will occur with the following code in SQL Server 2005 if executed by Alice?
• You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
• You cannot execute procedures on the 2005 server. Why not?
• What does HAS_DBACCESS() do?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• More...