Entra ID Authentication Issues for SSIS Deployment in SQL Server 2022

David B Forbush 0 Reputation points
2024-10-04T21:14:32.7466667+00:00

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?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,108 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,708 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,511 Reputation points
    2024-10-07T03:10:12.84+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.