May 14, 2024 at 12:41 pm
We've been testing out Azure SQL Managed Instance and created SSIS packages to run against it. We set connections using the ADO.Net connection manager and all worked well.
We recently had to apply MFA to all logins and this is causing issues within SSIS as there is no MFA option for logins like there is in SSMS. We can connect if we use SQL Server Authentication but we'd rather not do that. When using Active Directory Integrated Authentication, all of our test connections fail and the package will not run locally. In SSMS, there is an integrated authentication with MFA option and that works from within SSMS.
In ADF, we run the package under the Managed User Identity. I know in SSIS, you can set ConnectUsingManagedIdentity to True, but I do not believe this allows you to run it locally against the database in Azure. It also doesn't appear to alter the actual connection string.
How can we use SSIS and connect to the database using Windows Authentication when MFA is required and run it locally before publishing?
May 14, 2024 at 5:10 pm
check the sql connection driver you are using, these links detail further
Or a system\user managed identity
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2024 at 4:48 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply