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.

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.

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: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Tasks

Troubleshooting Package Development

Concepts

Troubleshooting Package Execution

Improving the Performance of the Data Flow