Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

How to fix SQL Server Integration Services could not be started issue?

Rajanand Ilangovan's photo
Rajanand Ilangovan
·Oct 1, 2022·

1 min read

Error:

The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for details.

image.png

image.png

Solution:

  1. Go to Administrative Tools and click Local Security Policy.
  2. Expand Local Policy, click User Rights Assignment. In the right pane, right-click Log on as a service and select Properties.
  3. Click Add User or Group option to add the new user. (Reference)
  4. You can add the "NT Service\MsDtsServer120" account. This option was not enabled for me due to windows version compatibility issue. image.png
  5. But, I was unable to add any user to "Log on as service". So I have changed the "Log on As" user to local system. image.png
  6. SSIS service is running now. image.png

The same approach can be used for other SQL Server related services like SQL Server agent, SSIS, SSRS, SSAS etc.