Post reply

SSIS firewall port

  • August 5, 2015 at 5:51 pm

    #310738

    Hi,

    We have SSIS packages deployed and scheduled on SQL_Server_A. The packages have to access databases on SQL_Server_B, which is behind a firewall.

    Question: would opening only SQL port between these two servers be enough or some other ports have to be open as well? (The packages only select and bring data back to Server_A or transfer data from Server_A to the databases and do inserts. Nothing else.)

    Thank you for your advice!

  • August 5, 2015 at 11:34 pm

    #1817752

    alark (8/5/2015)

    Hi,

    We have SSIS packages deployed and scheduled on SQL_Server_A. The packages have to access databases on SQL_Server_B, which is behind a firewall.

    Question: would opening only SQL port between these two servers be enough or some other ports have to be open as well? (The packages only select and bring data back to Server_A or transfer data from Server_A to the databases and do inserts. Nothing else.)

    Thank you for your advice!

    You only need the the same ports as any other database connecrion, the tcp port that the sql server is configured on and the 1434 udp for the browser service if it is a named instance.

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply