How to install a FMS Repository using SQL Server with gMSA in Foglight 6.1 (4309105)

When the user tries to install SQL Server with Windows authentication

The message is

Configuring External SQL Server Foglight Repository, by using Windows Authentication in service mode, the windows user password can not be empty.

To resolve this issue

1. Install the FMS repository using SQL Server authentication

2. Give permissions to the account in the repository (in this example it is gMSA02$)

3. Change the service of Foglight to logon as gMSA02$ user

4. Update the server.config file (located in the FMS\config directory) with the connection information specific for the database URL.

# If a JDBC URL is specified here it will take precedence over individual database 
# connection parameters (host, port, etc.)
#
server.database.url = "jdbc:sqlserver://servername[\instancename][:portnumber]];databaseName=foglight;integratedSecurity=true";

an example of the URL may be

server.database.url = "jdbc:sqlserver://fog2333sqlm2:1433;databaseName=foglight;integratedSecurity=true";

5. Restart Foglight

6. Repeat the connection attempt