Configuring firewall settings for SQL Server Integration Services (SSIS) on Windows 2008 R2
Here we will show step-by-step configuration of firewall settings for SQL Server Integration Services (SSIS) on Windows 2008 R2 server.
Firewall configuration for SSIS is little different from database engine or SSAS or SSRS. Here we have to open port as well as to allow connection to execute MsDtsSrvr.exe
Following are the steps to be followed for this activity: –
1) Go to Administrative tools and open Windows Firewall with Advanced Security utility.
2) Navigate to inbound rules and go to New Rule option, in order to create new rule.
3) In this new inbound rule window, select the rule type as Program and move to next step.
4) Here select the option “this program” and then click on Browse. Then navigate to the path where MsDtsSrvr.exe is stored. If you have installed SQL Server 2008 on C drive then path will be like “C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.exe”
Once you have selected the program, move to next step.
5) Under action tab, select the option “allow the connection” and move next.
6) Here Select Domain to allow connections from same domain only. Or select appropriate option as per your requirement and move forward.
7) Name this rule as SQL Server Integration Services and click on Finish.
8) Now you can see, this new rule is visible under inbound rules tab and is enabled by default. Move to next step.
9) Again, navigate to Inbound rule and right click –> New rule
10) Now, select the rule type as port.
11) Protocol type will be TCP and port number at which SSIS will listen is 135. Move to next step.
12) Select the action as “Allow the connections” and move next.
13) Here select the appropriate option. Normally it should be similar to what was selected in step 6
14) Name this rule as RPC(TCP/135) and click on finish.
15) Verify this newly created rule is created and enabled by looking at the inbound rules.