Running SSIS packages with AD proxy

Matt Brooks 1 Reputation point
2021-07-30T08:07:43.007+00:00

Hi,
We're in the process of moving out on premise SQL environment to an Azure SQL Managed Instance.
We have some complex SSIS packages which we have migrated to Data Factory with SSIS Integration Runtime and linked to the new Managed Instance and the mostly work fine when triggered from the SQL agent.
Some of the SSIS packages have links to our on premise storage where the business amend and update files which our database consumes.
In order to access this data we currently use a AD proxy account which has access to the folders where the files are stored.
We have enabled AAD on the Managed Instance and confirmed that this is working and all required accounts have access.
We've tried to add the AD account as a proxy on the Managed Instance but we don't appear to be able to create the Credential to link the proxy to the ad user.

Is it possible to use an AD account as a proxy on SQL Managed Instances to allow us to run our SSIS packages with this proxy so we can access files on prem?

Many Thanks
Matt

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,828 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,871 Reputation points
    2021-08-02T06:54:01.543+00:00

    Hi @Matt Brooks , welcome to Microsoft Q&A! Sorry about that I am work with SSIS, not familiar with Azure. But base on my research, SQL Managed Instance supports traditional SQL Server database engine logins and logins integrated with Azure AD. Please refer to below link:
    Azure Active Directory integration

    0 comments No 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.