Error Could not load package "XXXXX" because of error 0xC00160AA. Description: Connect to SSIS Service on machine "XXXXX" failed: The RPC server is unavailableConnect to SSIS Service on machine “XXXXX" failed: The RPC server is unavailable
If you have two servers one running SQL Server Agent (SERVER A) and the other Integration Services (SERVER B) and you want to be able to run the SSIS packages on SERVER B from the Agent on SERVER A, you need to properly configure the firewall on SERVER B, if you don’t do it, you will run into the following error:
Error Could not load package "XXXXX" because of error 0xC00160AA. Description: Connect to SSIS Service on machine "XXXXX" failed: The RPC server is unavailableConnect to SSIS Service on machine “XXXXX" failed: The RPC server is unavailable
To configure the firewall follow these steps:
- Allow the C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.exe to go though the firewall, you can do it with an exeption in Windows 2003 or an Access Rule in Windows 2008.
- Allow the traffic for TCP port 135
**********************************************************************************
Si tienes que ejecutar paquetes que están en un servidor remoto tienes que asegurarte que el firewall del servidor remoto está correctamente configurado, para eso debes permitir trafico por el puerto TCP 135 y crear una excepción para el archivo C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.exe
Saludos,
Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP
Costa Rica
Technorati Tags: SQL Server
LiveJournal Tags: SQL Server
del.icio.us Tags: SQL Server
http://ecastrom.spaces.live.com
http://universosql.blogspot.com
http://todosobresql.blogspot.com
http://todosobresqlserver.wordpress.com
http://mswindowscr.org/blogs/sql/default.aspx
Comments