A user who wants to add SQL Server for monitoring with Active Directory authentication by using Foglight Agent Manager with AD (Active Directory) in place, once the user specifies the credentials, the FglAM will try to connect to the server with user from FglAM's service, not the AD user that is specified.
This occurs only on Windows FglAMs using the 7.3.0.10 SQL Server cartridge.
An error similar to the following appears in the SQL Server installer log file
Failed to establish a SQL-Server JDBC connection protocol to Host [HOSTNAME\DEFAULT_INSTANCE], user account [DOMAIN\USER] . Reason : [Login failed for user 'DOMAIN\SERVICEUSER$'. ClientConnectionId:3375a3fc-7449-46fb-beb6-21a79d01a5d0- Profile:MSSQLProfile{host='HOSTNAME', instance= 'DEFAULT_INSTANCE', username='DOMAIN\USER', authType= 'WINDOWS_CUSTOM', port= '0' useNTLMv2= 'false', socketTimeout= '900', database= 'master', secureConnection= 'OFF', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', lockTimeout= '10000', codePageOverride = '', selectMethod='' }]. . [SQL-Server Error Code = 18456. SQL state : S0001]
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.
