Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document.
Note: Even the most advanced machine translation cannot match the quality of professional translators.
Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
How Do I Do If the SQL Server Running User Fails to Be Checked During Secondary Installation or Upgrade of eSight
Question
During the eSight environment check, "The user of MSSQLSERVER is not NETWORKSERVICE" is displayed on eSight Console.
Answer
During installation, secondary installation, upgrade, startup, and environment health check of eSight, the system checks whether the MSSQLSERVER running user is NETWORKSERVICE. If no, the backup and restoration function of eSight is unavailable.
To rectify the fault, perform the following steps:
- Log in to the eSight server.
- Check the SQLServer running user.
- Choose Start > Search and enter services. Click Services in the search result.
- Find the record whose Name is SQL Server (MSSQLSERVER). Check whether the value in the Log On As column is Network Service. If no, go to the next step.
- Choose Start > Search and enter services. Click Services in the search result.
- Right-click SQL Server (MSSQLSERVER) and choose Properties from the shortcut menu.
- In the SQL Server (MSSQLSERVER) Properties (Local Computer) window, click the Log On tab page, select This account, and click Browse.
- In the Select User window, enter Networkservice and click Check Names.
- When the corresponding object name is displayed, click OK.
- In the SQL Server (MSSQLSERVER) Properties (Local Computer) window, delete the values automatically set by the system for Password and Confirm password. Click OK.
- In the Services window, click OK.
- Right-click the eSightData directory and choose Properties from the shortcut menu.
The eSightData directory varies according to the installation directory selected during eSight installation.
- In the eSightData Properties window, click the Security tab page and click Advanced.
- In the Advanced Security Settings for eSightData window, click Add.
- In the Permission Entry for eSightData window, click Select a principal.
- In the Select User, Computer, Service Account, or Group window, enter network service and click Check Names.
- When the corresponding object name is displayed, click OK.
- In the Permission Entry for eSightData window, select Full control. Click OK.
- In the Advanced Security Settings for eSightData window, select Replace all child object permission entries with inheritable permission entries from this object and click OK.
- In the displayed Windows Security window, click Yes.
- In the eSightData Properties window, click OK.
- In the Services (Local) window, select SQL Server (MSSQLSERVER) and then click Restart the service.
