Deploy a SSIS Package to ADF(Azure Data Factory).

Question

I am trying to deploy a SSIS package to an ADF SQL Server. In the deployment wizard, when i want to Deploy our SSIS Package with SQL Server Authentication, it gives me the below error:

The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication. (Microsoft SQL Server, Error: 27123).

As far as I understand, it is saying that I must use Integrated(Windows) Authentication.so, i have tried to connect with Integrated(Windows) Authentication but we are unable to connect,it gives me the below error:

Answer 1

Hi @ashok reddy ,

You can use Windows authentication to access data stores, such as SQL Servers, file shares, Azure Files, etc. from SSIS packages running on your Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF).

Please refer these documentations about the authentication for ADF.

ssis-azure-connect-with-windows-auth

enable-aad-authentication-azure-ssis-ir

move-local-ssis-packages-to-azure-data-factory

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.