question

MattBrooks-9749 avatar image
0 Votes"
MattBrooks-9749 asked ShaikMaheer-MSFT commented

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

azure-data-factoryazure-sql-database
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MattBrooks-9749 ,

Following up to check is below answer provided by @CarrinWu-MSFT helps you? If Yes, Please Accept Answer. Accepting answer helps community too. Please let us know if any further queries. Thank you.

0 Votes 0 ·

Hi @MattBrooks-9749 ,

Just checking is below answer provided by @CarrinWu-MSFT helps you? If Yes, Please Accept Answer. Accepting answer helps community too. Please let us know if any further queries. Thank you.

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @MattBrooks-9749, 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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.