I am trying to execute a SSIS package deployed in the SSISDB. while using windows authentication the package executes without any problem but when I try executing it with a SQL server authentication user I get 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."
Here is my code to execute to package.
declare @parameterValue nvarchar(200)set @parameterValue='D:\DriverImpact\'declare @output_execution_id bigintdeclare @execution_id bigintexec ssisdb.catalog.create_execution
@folder_name = 'DriverImpact'
,@project_name = 'Integration Services Project2'
,@package_name = 'Package1.dtsx'
,@execution_id = @execution_id outputEXEC [SSISDB].[catalog].[set_execution_parameter_value]
@object_type= 20
,@execution_id = @execution_id
, @parameter_name = N'MainFolder'
, @parameter_value = @parameterValue;exec ssisdb.catalog.start_execution @execution_id
set @output_execution_id = @execution_id
select @output_execution_id as 'output'