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)
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;