SQL Server 2022 SSIS Package Exception 6522 internal.start_execution_internal

Question

I'm configuring execution of the SSIS package using SQL procedures in SSISDB database. When the calling account is in sysadmin the package runs succesfully. I'm using SQL Server 2022 developer and SQL Server 2017 developer.

When the calling account is given ssis_admin but not sysadmin privileges I get a .NET exception.

The internal.start_execution_internal is a compiled code so I can't debug it.

Is there a way to properly debug this issue? Any idea how to resolve this issue?

Thank you

Error: 6522 internal.start_execution_internal A .NET Framework error occurred during execution of user-defined routine or aggregate "start_execution_internal":   System.Data.SqlClient.SqlException: The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication.  System.Data.SqlClient.SqlException:      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)     at System.Data.Sq

Answer 1

Hi @Maciej Skierski,

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

The issue is that you cannot execute SSIS packages using a SQL Server account.

Try to use proxy account which has full permission to run the pakcage.

Running a SSIS Package from SQL Server Agent Using a Proxy Account

Regards，

Zoe Hui

---

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