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.



Expert SQL Server 2005 Integration Services
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
ISBN: 0470134119
EAN: 2147483647
Year: 2004
Pages: 111

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net