Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Patch Manager > Patch Manager - Knowledgebase Articles > Unable to generate Patch Manager reports and access Managed Computers

Unable to generate Patch Manager reports and access Managed Computers

Overview

When you run a report or expand the Managed Computer group, both attempts fail. 

Environment

  • All Patch manager versions
  • MS SQL - All supported versions

Cause 

SQL permissions are not assigned to ewreportuser.

Resolution

  1. Open SQL Server Management Studio.
  2. Navigate to Eminentware db > Security > Logins and select ewreportuser.
  3. Right-click > Delete.
  4. Open the Server Security > Logins and select the ewreportuser.
  5. Right-click >Delete.
  6. Right-click Logins > New Login.
  7. Name the new login:
    ewreportuser,
    No password is required.
  8. Set the default schema to Master.
  9. Go to User Mappings and select Eminentwaredb.
  10. Assign Eminentwaredb with public and db_owner permissions.
  11. Go to the Eminentware db logins.
  12. Make sure the account displays and has the proper permissions.
    You can now run the reports.
 

 

Last modified

Tags

Classifications

Public