Retour
-
Titre
"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." with SQL Server 5.9.7.10 through 5.9.7.21 cartridges -
Description
A user is attempting to create a SQL Server agent or validate a SQL Server agent and it fails with an error similar to the following below. The remote host can be pinged (i.e. there are no network connectivity issues) and the port is accessible from the FglAM (agent manager).
ERROR [FglAM:IncomingMessage[5]-18] com.quest.qsi.fason.framework.connections.mssql.MSSQLPool - Failed to validate MSSQL connectioncom.quest.qsi.fason.framework.connections.common.exceptions.FrameworkConnectionException: [Foglight][SQLServer JDBC Driver][SQLServer]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.- Profile:MSSQLProfile{host='HOSTNAME', instance= 'INSTANCENAME', username='DOMAIN\USER', authType= 'WINDOWS_CUSTOM', port= '0' useNTLMv2= 'true', socketTimeout= '900', database= 'master', secureConnection= 'OFF', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', lockTimeout= '10000', codePageOverride = '' } -
Cause
JDBC driver issue -
Résolution
WORKAROUND
Please review KB article 92135 for numerous other resolutions for this error message.
STATUS
Upgrade to the 5.9.7.22 and higher releases of the SQL Server cartridge.
Enhancement Request FOG-1582 was included in the 5.9.7.22 and higher releases of the SQL Server cartridge to replace the third party DataDirect SQL Server driver with the Microsoft SQL Server driver.