Can I Create Azure SQL Database connection with Active Directory with MFA (Multi-Factor Authentication)

@davidrich The SQL Server reader / writer does not yet support Active Directory and it doesn't look like there is a work around when using the SQL server reader/writer. However, you might be able to connect via the native JDBC reader/writer. It looks like it is possible to formulate the JDBC connection string to use Active Directory. You might also try an ODBC Active Directory connection.

Hi @chris,

Unfortunately, there is no update to this functionality just yet - only the JDBC workaround that Mark mentioned above. We will be sure to update this post if the status of this changes; however if you would like to stay informed via email, I would recommend submitting a case through our Report a Problem webform and reference the enhancement request: FMEENGINE-57594.

Additionally, if you would like to help move this along and get support from others in the community, it may be worthwhile to post this as a suggestion on our Ideas page.

Just to bump this thread again. Would anyone be able to supply and show the methods alluded to marks message previously " It looks like it is possible to formulate the JDBC connection string to use Active Directory. You might also try an ODBC Active Directory connection." We're trying to come up with a solution to this. On 2020.1.

Hi @veenendaalo​,

For better visibility, I'd suggest posting a new question and linking back to this one for context if needed. It would also help generate discussion if you could tell us more in the new post about where you seem to be stuck in the setup so the Community can best help you. Any screenshots would also help illustrate the issue. Thanks!