How to change FMS (Foglight Management Server) to use Windows integrated authentication for SQL Server repository database (4255146)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

How to change FMS (Foglight Management Server) to use Windows integrated authentication for SQL Server repository database
说明

FMS 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?
原因

Windows Integrated authentication uses the service account used to run the Foglight Windows Service to login to the repository database automatically.
解决办法
1. Make a backup copy of the server.config file located at [FOGLIGHT_HOME]\config, then open the original for editing.

2. Edit the server.config as below:
```
server.database.user = "";
server.database.password = "";
server.database.integratedauth = "true";
```
Note: Integrated authentication does not need user/password set in the server.config (even if set, the server just ignores it), FMS will use logged in windows user to connect to the sql server.

3. Stop and Start the Foglight Windows Service

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

产品：: Foglight for Databases
6.1.0, 6.0.0, 5.9.7; Foglight Evolve
6.1.0, 6.0.0; Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7

标题