SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.




download SQL Server 2014



Connect to SSIS Service on machine "{ServerName}" failed: The RPC server is unavailable. Windows Firewall configuration.


I have two MS SQL Server 2008 instances on two computers running as Developer Edtions.
Recently, I wanted to connect to remote SQL Server SSIS instance from my computer and I got the following error messages.
Connect to SSIS Service on machine "ISTW1029" failed: The RPC server is unavailable.

SSIS Remote Connection Error

I later realized that this problem is caused since the Windows Firewall is active on the remote computer.
And since during installation I did not added the SSIS application and the SSIS ports in the firewall exception list, these ports and applications were not accessible.
After I had configured the Windows Firewall on the remote computer, I successfully managed to connect to remote SSIS server.
Check the below section for configuring Windows Firewall for SQL Server Integration Services.

TITLE: Connect to Server
------------------------------

Cannot connect to ISTW1029.

------------------------------
ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

Connect to SSIS Service on machine "ISTW1029" failed:
The RPC server is unavailable.

Here is far more detailed information about the error:


===================================
Cannot connect to ISTW1029.
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Connect to SSIS Service on machine "ISTW1029" failed:
The RPC server is unavailable.
.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
===================================
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)





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.
And browse to the folder where the SQL Server instance installation folders.
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.exe is the default installation folder.

Microsoft SQL Server 2008 Integration Services SSIS

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

Add MsDtsSrvr as an Exception on Windows Firewall

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.

Configure TCP port 135 as Exception for SSIS

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





SSIS-Integration Services

SSIS Tutorial List

SQL Server Articles

SQL Blog

Certification Exams Blog



Free Exam Vouchers










Copyright © 2004 - 2014 Eralper Yilmaz. All rights reserved.
Community Server by Telligent Systems