-
Title
Unable to add a SQL Server instance to Foglight from different domain -
Description
How to add a SQL Server instance which is located in a different domain to Foglight?
For example: Foglight Agent Manager (FglAM) is in PROD domain but the target host is in DEV domain.
Account FOGLIGHTSA is member of the Administrators group on TARGET_HOST.myDomain.com
The following error appears:
Failed to establish a SQL-Server JDBC connection protocol to Host [TARGET_HOST.myDomain.com\DEFAULT_INSTANCE], user account [PROD\FOGLIGHTSA] . Reason : [[Foglight][SQLServer JDBC Driver][SQLServer] Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.- Profile:MSSQLProfile{host=TARGET_HOST.myDomain.com', instance= 'DEFAULT_INSTANCE', username='PROD\FOGLIGHTSA', authType= 'WINDOWS_CUSTOM', port= '0' useNTLMv2= 'true', socketTimeout= '900', secureConnection= 'OFF' }]. . [SQL-Server Error Code = 18452. SQL state : HY000]
-
Cause
Foglight Agent manager server is unable lo locate the Netbios Name (Shortname, without the domain) of the target server.
-
Resolution
WORKAROUND 1
Add TARGET_HOST.myDomain.com and the IP Address into the DNS server records that the FglAM is using (PROD domain DNS server)
WORKAROUND 2
Add the target host entry into the etc/hosts file of the FglAM.
In Windows is located in:
c:\windows\system32\drivers\etc\hosts
In Linux is located in:
/etc/hosts
Example:10.10.10.10 TARGET_HOST.myDomain.com TARGET_HOST
Try the connection using the FQDN in the Username field, In this example will be like this:PROD.QUEST.CORP\FOGLIGHTSA