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

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

https://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/