Foglight Management server installation fails with error below when the installation is configured to use an external Microsoft SQL identified by a named instance.
“Failed to connect to the database as the administrator user:sa”
This issue is a known Issue: FGL-12840: The Management Server fails to start when configured to use an external Microsoft SQL Server database that is identified by a named instance instead of a port number during installation.
Use port number instead of the SQL Server instance name. To determine the port number used by an instance, find following keys from registry and check the key [TcpPort] key value:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\TCP\IPAll \TCP
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.(InstanceName)\MSSQLServer\SuperSocketNetLib\TCP\IPAll
1. Find the registry key for the SQL instance, for example,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#( where # is the number).
The instance name is stored as the default value for this registry key – it is MSSQLSERVER for a default instance.
2. Once the instance name is located, check the TCP/IP registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\MSSQLServer\SuperSocketNetLib\TCP\IPAll