9.5. Firewall Issues
To connect to a package store, the SSIS service must be started on the given server. Additionally, you must have TCP/IP port 135 open between your machine and the server. This port is a common port used for the Distributed Component Object Model (DCOM), and many network administrators will not have this open by default. You'll also need to have the SQL Server database engine port open (generally TCP/IP port 1433) to connect to the package store in the msdb database.
Get Expert SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
