The AAD connection in the Azure SQL database cartridge 6.1.5.10 fails with an error similar to the following in agent log files
ERROR [ConnectionManagementThread-[AzurePool-sqlsrv-azautomate-prd.database.windows.net-sqldb-azautomate-prd]-[Tue Feb 07 16:51:26 MST 2023][AzureProfile{server='HOSTNAME', database= 'DBNAME', username='USERNAME', authType= 'SQL_SERVER', port= '1433', socketTimeout= '0', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', lockTimeout= '10000', codePageOverride = '' }]] com.quest.qsi.fason.framework.connections.jdbc.JDBCConnectionImpl - Failed to create new connection. [AzureProfile{server='HOSTNAME', database= 'DBNAME', username='USERNAME', authType= 'SQL_SERVER', port= '1433', socketTimeout= '0', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', lockTimeout= '10000', codePageOverride = '' }]
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server "SERVERNAME" requested by the login. The login failed. ClientConnectionId:d0203275-1adb-4276-aea7-30d6b50ec7a7
Even though Azure Active Directory is being used as the connection type as shown here:
monUserAuthentication=Azure_Active_Directory
The authtype being passed to in the JDBC connection is authType= 'SQL_SERVER'
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center