SSIS from the remote machine it says that "RPC servers is unavaiable" | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSIS from the remote machine it says that "RPC servers is unavaiable"

When i was connecting to SSIS from the remote machine it says that "RPC servers is unavaiable"
I am using SQL server 2008 and the remote machine is Windows 2008 and the windows firewall is off.
Please help . it is a urgent one. how to overcome this.?

This is a very generic message. If you have installed all software properly, server names are correct, you can ping them from client, and no firewall issues in between, you can check on two things
  1. Check whether the RPC service is running in the server
  2. Check this site: it may be your problem too:
http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/3f0c8abc-fb6b-41a1-8c46-577b8f2a01a8/

See this http://www.kodyaz.com/articles/ssis…remote-connection-rpc-server-unavailable.aspx post to follow..

Welcome to the forums
I believe you have to restart the SSIS service, as I was stumbled upon similar issue few times before and able to do by checkng what Preethi referred plus restarting the service.,

Thanks Preethi/Sathya
I restarted the SSIS, followed the instruction from preethi but still it is shows "RPC server is unavaible"

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |