Entra ID Authentication Issues for SSIS Deployment in SQL Server 2022

Question

The scenario involves two users, both configured with Entra ID and the sysadmin role for SQL Server 2022. While one user can successfully deploy SSIS projects to the target SSIS catalog, the other user encounters an error message stating: "The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication." This occurs despite selecting Microsoft Entra Interactive Authentication during the deployment process with the Integration Services Deployment Wizard in Visual Studio 2022. Both users are following the same steps. What could be causing this discrepancy?

Answer 1

Resolved! Only an Entra ID administrator could properly add the user from the Entra user pool. When anyone other sysadmin account attempted to do it, it would appear to pull the user from the Entra pool, but, in reality, it was adding them as a SQL database user. @ZoeHui-MSFT , you should note this as there is literally zero documentation for this online. We can now deploy with Microsoft Entra Interactive Authentication with any account that is given sysadmin as long as that account is first added to the server by our Entra ID administrator.

Answer 2

Resolved! Only an Entra ID administrator could properly add the user from the Entra user pool. When anyone other sysadmin account attempted to do it, it would appear to pull the user from the Entra pool, but, in reality, it was adding them as a SQL database user. @ZoeHui-MSFT , you should note this as there is literally zero documentation for this online. We can now deploy with Microsoft Entra Interactive Authentication with any account that is given sysadmin as long as that account is first added to the server by our Entra ID administrator.

Answer 3

Hi @David B Forbush,

If you're deploying to a SQL Server with the Deployment Wizard, you have to use Windows authentication; you can't use SQL Server authentication.

If you're deploying to the logical server for your Azure SQL Database, you have to use SQL Server authentication or authenticate with Microsoft Entra ID (formerly Azure Active Directory); you can't use Windows authentication.

Authentication methods for deployment

Regards，

Zoe Hui

---

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