"User does not have permission to perform this action" error while changing user permissions in pVault

Issue

When trying to make user permissions changes in account settings--such as giving a reviewer edit invoice permissions--the following error displays:

Program:     .Net SqlClient Data Provider
Error:     System.Data.SqlClient.SqlException

Module versions:     pVault.exe, Version X.X.X.X

Description:     User does not have permission to perform this action.

Resolution

This issue is usually due to the paperless account in SQL not having proper permissions.

Important:  Before beginning the resolution steps, make sure to be in the proper SQL instance by verifying the SQL SERVER NAME field on the pVault Application Server Dashboard, SQL SERVER tab.

1. From the Start menu, type SQL Server Management Studio.

2. Log in.
   The Microsoft SQL Server Management Studio screen displays:
   

   

   
   

3. From the left navigation bar, click Security.

4. Click Logins.
   The left navigation bar will resemble the following:
   
   

   

   
   

5. Right-click on paperless to display a dropdown menu similar to the following:
   
   

   

6. Click Properties.
   The Login Properties window similar to the following displays with the General view active:
   
   

   

7. Click the Server Roles view.
   The following window displays:
   
   

   

   
   

8. Verify that the following Server Roles are selected:
   

   1. securityadmin

   2. serveradmin

   3. diskadmin
      
      Note:  public is a system default.
      

9. Click OK.