Security Compliance

How to recreate the ewreportuser SQL user for Patch Manager reports

Sometimes it is nessesary to recreate the EWReports user. This can be due to DB migration or because the account was removed.

First published date

11/6/2018 9:28 PM

Last published date

11/6/2018 9:28 PM

Overview

Sometimes it is nessesary to recreate the EWReports user. This can be due to DB migration or because the account was removed.

Product section

Patch Manager

Resolution

Verify that the service account running the Eminentware Data Grid Service has SA rights on the database (it needs this to do the changes below). If you had demoted it to db_owner, you can promote it temporarily then demote again after.
Close the Patch Manager console.
Open a Command Prompt on the Patch Manager server, and then change directories to the Server folder in the Patch Manager installation folder. By default: %PROGRAMFILES%\Solarwinds\Patch Manager\Server.
Enter the following command, where sqlServer is the hostname or IP address of the affected SQL server, and serviceAcct is the Patch Manager service account:
```
dbhelper /s sqlServer\instance /p createlogins /u serviceAcct /o c:\output.ini
```
Restart the EminentWare Data Grid Server service.
Open the Patch Manager console and rerun the report.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.