How to change the Foglight repository to use Windows Authentication instead of SQL Server Authentication (4258033)

How to change the Foglight repository to use Windows Authentication instead of SQL Server Authentication

Foglight has been configured to use a SQL Server account to connect to the external SQL Server repository database.

How can it be changed to use Windows Integrated Authentication instead?

What are the steps to change the authentication used by a Windows Foglight Management Server (FMS) from SQL Server Authentication to Windows Authentication?

When Windows Authentication is used the FMS will attempt to connect to the SQL Server repository as the user the FMS is running as. If the FMS is not on the same host as the SQL Server database then the user that Foglight is started as must be a domain user.

Execute the following steps to change the FMS to connect using Windows Authentication to the SQL Server repository:

1. Verify that the Foglight service is set to start up as a Windows user that can connect to the SQL Server database.
2. Back up the server configuration file [FMS_HOME]\config\server.config.
3. Change the database user, password, and integrated authentication settings in the configuration file to the following values to enable Windows Authentication:
   • server.database.user = "";
   • server.database.password = "";
   • server.database.integratedauth = "true";
4. Restart the Foglight Service.

Note: Integrated authentication does not need user/password set in the server.config (even if set, the server will ignore it).