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:
- Verify that the Foglight service is set to start up as a Windows user that can connect to the SQL Server database.
- Back up the server configuration file [FMS_HOME]\config\server.config.
- 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";
- 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).