The operation cannot be started by an account that uses SQL Server Authentication error When running ssis from stored proc in SSRS

Question

I am getting the following error:

The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication

I have a ssrs report which uses a dataset derived from a stored procedure. The stored procedure first creates an execution and executes a ssis package before drawing the data. In visual studio I can preview the report fine. The data source uses integrated security (though I wish I could pass a sql server account). When I upload the report to SSRS it gives me the error about using an account with windows auth. I checked the datasource on the server and it is set to use windows auth. I'm not sure what I am doing wrong or how to fix this.

my sql server is 2012 r2 (ssrs is 2008)

Answer 1

The issue is that you cannot execute SSIS packages which are stored on your SSISDB Catalog using a SQL Server account.

This is why changing the user which is attempting to start the SSIS package to a 'Windows Authentication user' works.

A similar issue can be found here;

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bbd2b556-8f68-4e04-94d1-754127886361/unable-to-execute-ssis-package-from-sql-server-login?forum=sqlintegrationservices