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
Running SSIS packages with AD proxy
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
1 answer
Sort by: Most helpful
-
CarrinWu-MSFT 6,871 Reputation points
2021-08-02T06:54:01.543+00:00