SQL Database Connection when Authentication is set to MFA
Hi,
So far I was connection via KNIME to a database in MS SQL Management Studio by using the “Database Connector” and configuring the node as follows:
Database driver: com.microsoft.sqlsever.jdbc.SQLServerDriver
Database URL: jdbc:sqlserver://xxxxxx.database.windows.net:1433;database=aaaaa;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword
user name & password: myname@mycompany.com and my windows password
and I was able to access the database and the tables.
Now, our corporate IT department changed the authentication in the SQL database to be:
Active Directory - Universal with MFA support
Of course the KNIME “Databas e connector” in KNIME does not load and give an error
could not create connection to database ID:3242 the security token could not be authenticated or authorized
How do I need to amend my KNIME connection to account for the change?