DBA > Job Interview Questions > Microsoft SQL Server FAQs

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