Troubleshooting the Integration Services Service
The Integration Services service is the component of SQL Server 2005 Integration Services (SSIS) that monitors and manages packages. You can monitor running packages and manage saved packages by connecting to an instance of Integration Services in SQL Server Management Studio. For more information, see Managing the Integration Services Service.
Troubleshooting Service Startup
The Integration Services service is installed when you install Integration Services. By default, the service is started, and its startup type is set to Automatic.
When you connect to Integration Services, you must specify the name of the server to connect to. If you cannot connect to Integration Services on the specified server, consider trying the following troubleshooting steps:
- Verify the startup type of the service. Open SQL Server Configuration Manager or the Services snap-in to verify that the service startup type is set to either Manual or Automatic. If the startup type is set to Disabled, you must change it to Manual or Automatic and start the service before you can connect to Integration Services.
- You do not have to start the service manually. When you connect to Integration Services in SQL Server Management Studio, the Integration Services service is started automatically, if it is not already running.
Troubleshooting Service Permissions
If you cannot connect to Integration Services on the specified server, and you have already verified that the service is running, consider the following troubleshooting steps:
- Verify that a firewall is not preventing you from connecting to the server. For information about configuring a firewall to allow access, see Configuring a Windows Firewall for Integration Services Access.
- Verify that you have the required permissions to connect to the service on the specified server. For information about configuring the required permissions, see Connecting to a Remote Integration Services Server.
Change History
| Release | History |
|---|---|
17 July 2006 |
|
See Also
Tasks
Troubleshooting Package Development
Concepts
Troubleshooting Package Execution
Troubleshooting Package Performance