Export (0) Print
Expand All

Troubleshooting the Integration Services Service

The Integration Services service is the component of SQL Server Integration Services 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.

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.

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:

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft