As with any other Windows service, the Integration Services service has properties that dictate how it is to be started. Specifically, you can manage the following from the Windows Services Snap-in:

1. Configure the startup type as Manual, Automatic, or Disabled.

2. Request that the service is started, stopped, or restarted.

3. Establish how the computer reacts to service failures.

4. View or modify a listing of dependant services (none are set up by default).

To view and modify SSIS services properties using the Windows Services Snap-in, follow these steps:

1. Open the Services Snap-in from Control Panel And then Administrative Tools (or using the Category view from Performance and Maintenance And then Administrative Tools).

2. Locate and right-click SQL Server Integration Services in the list of services.

3. Select Properties to view the currently applied settings.

4. On the General tab, you can view or change the Startup type (Automatic, Manual, or Disabled).

When set to either Manual or Automatic, you can change the Service status to Start, Stop, or Resume.



5. On the Log On tab, you can view or alter the account used to start and run the service. By default, this runs under the NT AUTHORITY\NetworkService account.

6. On the Recovery tab, you can configure how the server responds to failures of the service by setting the First, Second, and Subsequent failures options to either Take No Action (the default), Restart the Service, Run a Program, or Restart the Computer.



You can also instruct the service to reset the failure count after a certain number of days.