AD authentication does work with SQL Server agents on Windows Agent Manager in 7.3.0 (4377930)

Active Directory (AD) authentication does work with SQL Server agents on Windows Agent Manager in 7.3.0.

Cannot add new SQL Server agents using NTLM in Foglight 7.3.0 and existing SQL Server agents can no longer connect. 

An error similar to the following appears in the SQL Server installer log file

ERROR   [FglAM:IncomingMessage[5]-14] com.quest.qsi.fason.sqlserver.installer.validation.DBSSDbValidator - Validation failed: cannot establish a DB connection to host wsprd1507.dom1.schneider.com with profile MSSQLProfile{host='HOSTNAME', instance= 'DEFAULT_INSTANCE', username='DOMAIN\USERNAME', authType= 'WINDOWS_CUSTOM', port= '1433' useNTLMv2= 'false', socketTimeout= '900', database= 'master', secureConnection= 'OFF', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', lockTimeout= '10000', codePageOverride = '', selectMethod='' } com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkException: Failed to establish a SQL-Server JDBC connection protocol to Host [SERVER\DEFAULT_INSTANCE], user account [DOMAIN\USERNAME] . Reason : [Integrated authentication failed. ClientConnectionId:08d80c88-d7bf-4792-9961-772568f3ac3e- Profile:MSSQLProfile{host='HOSTNAME', instance= 'DEFAULT_INSTANCE', username='DOMAIN\USER', authType= 'WINDOWS_CUSTOM', port= '1433' useNTLMv2= 'false', socketTimeout= '900', database= 'master', secureConnection= 'OFF', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', lockTimeout= '10000', codePageOverride = '', selectMethod='' }]. . [SQL-Server Error Code = 0. SQL state : 08S01]         at com.quest.qsi.fason.framework.connections.mssql.MSSQLPool.validateConnection(MSSQLPool.java:100) ... Caused by: GSSException: No valid credentials provided (Mechanism level: Fail to create credential. (63) - No service creds) ... Caused by: KrbException: Fail to create credential. (63) - No service creds

Defect

WORKAROUND

A SQL Sever 7.3.0.11 cartridge attached to this knowledgebase article which should be installed in the FMS. After installing the new cartridge, deploy the agent package to each Foglight Agent Manager.

Users must be logged into Support to download this cartridge.

STATUS

This issue has been logged as FOG-9730 which will be fixed in an upcoming release of the SQL Server cartridge.