Forum Discussion
ADF Execute SSIS Package Failed to Acquire Connection
I have deployed an SSIS package into SSISDB that has connections to Azure SQL Managed Instance. The connections use Azure Directory Integrated Authentication. I set up the SSIS IR to use a sql admin ...
I was able to get it to work by deleting SSISDB, updating the IR to use a managed identity and granting that identity access to the databases involved. In the package connection managers, I changed the ConnectUsingManagedIdentity to True. Is this the best/proper way to get it to work?