RPC Server Unavailable

Cause

This problem is caused if Windows Firewall is active on the remote computer and SSIS application and the SSIS ports are not added in the firewall exception list. After proper configuration of Windows Firewall on the remote computer, connection to remote SSIS server will be established.

How to Configure Windows Firewall for SSIS (SQL Server Integration Services)

To enable remote connection for MS SQL Server Integration Services (SSIS), you can configure the Windows Firewall application by following the below steps.

·         Open the Windows Firewall from the Control Panel menu.

·         Click on the Exceptions tab.

·         Click the "Add Program" button.

·         Browse to the folder where the SQL Server instance installation folders. (..\DTS\Binn\MsDtsSrvr.exe )

·         Click Open then on the next screen click OK button to add the SSIS executable to the application exceptions list.

·         Then the port # 135 should be added to the exceptions list as a TCP port. You can define any descriptive name on the Name textbox, but you should specify the port number 135 and define it as a TCP port.

After these Microsoft Firewall configuration updates, I could successfully connect to the MS SQL Server 2008 Integration Services (SSIS) without any problem.