Failed to start SSIS in SQL Server configuration manager.

Question

Microsoft SSIS Service failed to start using "NT Service\MsDtsServer150” as the logon account in SQL Server Configuration manger.

The error from the event viewer application log:

 

Microsoft SSIS Service failed to start.

Error: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Answer 1

Hi @Bing Wang,

That SSIS OS service is not needed at all starting from SSIS 2012 onwards.

It is kept for backward compatibility with the obsolete SSIS circa 2005 - 2008R2 era.

For the reference:

The topics in this section discuss the Integration Services service, a Windows service for managing Integration Services packages. This service is not required to create, save, and run Integration Services packages. SQL Server 2012 (11.x) supports the Integration Services service for backward compatibility with earlier releases of Integration Services.

https://learn.microsoft.com/en-us/sql/integration-services/service/integration-services-service-ssis-service?view=sql-server-ver16

Answer 2

Hi @Bing Wang,

Error: Access is denied.

It is a permission issue, you may follow the blog to give access to the account and then start SSIS.

Connecting to Integration Services Access is Denied in SQL Server

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.