-
Título
AAD connection to Azure SQL database fails in 6.1.5.10 cartridge -
Descrição
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_DirectoryThe authtype being passed to in the JDBC connection is
This issue is specific to the 6.1.5.10 Azure SQL cartridge.authType= 'SQL_SERVER' -
Causa
Regression issue -
Resolução
WORKAROUND
Contact Support for HFIX-384 for this issue
STATUS
This issue has been logged as defect FOG-5461 and has been fixed in the 6.1.5.11 and higher releases of the Azure SQL cartridge. -
ID do defeito
FOG-5461