We have a SQL Managed Instance that we are testing with. I'm attempting to create local packages in SSIS and have them run against the Managed Instance data.
When I manually run the SSIS package, I get an MFA validation. It works. However, when I try to schedule the package to run daily, it hangs and I assume it's due to the MFA.
What options do I have to get this to work? One that I can think of is to use a SQL account but I don't really want to change every single package and connection that I currently have. I'm currently taking existing connections and modifying them in notepad to point to the Managed Instance rather than our local server. It was working fine until our network team increased security and now require MFA to the database.
Can MFA be turned off just for the Managed Instance?