Azure SQL Managed Instances using AAD authentication. “Failed to authenticate” errors happen with the default MS driver.
Messages similar to the following appear in the agent log file.
ERROR [ConnectionManagementThread-[MSSQLPool-AGENTNAME]-[Sun Dec 18 05:04:28 EST 2022][ 2MSSQLProfile{host='HOSTNAME', instance= 'DEFAULT_INSTANCE', username='USERNAME@DOMAIN', authType= 'AAD_PASSWORD', port= '0' 3useNTLMv2= 'true', socketTimeout= '900', database= 'master', secureConnection= 'REQUIRE', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', 4lockTimeout= '10000', codePageOverride = '', selectMethod='' }]] com.quest.qsi.fason.framework.connections.jdbc.JDBCConnectionImpl - 5Failed to create new connection. [ 6 7com.microsoft.sqlserver.jdbc.SQLServerException: Failed to authenticate the user username@domain in Active Directory (Authentication=ActiveDirectoryPassword). 8 at
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center