Working to reduce reliance on static passwords for integration.
How can I create a sync job to connect to a SQL target system using Azure Active Directory integrated authentication? The account running the job service has access to the SQL I need, but the only provided options in the interface are SQL auth and windows auth. Neither of which meet the requirements.
If I check the extended box, I can set Security > Authentication to ActiveDrirectoyIntegrated, but the wizard will not let me move forward without a username and password unless I check windows authentication which is also incorrect.