SQL Role assignments needed


While running Deployment Scanner or Symhelp under Vault Service Account (VSA) logon, it fails on SQL - VIEW SERVER STATE Permission.

Event 13360 is generated when Enterprise Vault (EV), via the Vault Service Account (VSA), attempts to query the SQL database for metadata information during the scheduled Status Checks, that populate the Status section of the Vault Admin Console (VAC)

The Status section of the VAC reports errors on all checks that query SQL metadata.

Invalid User, please specify valid credentials of the Monitoring User, while running the EV Operations Manager Configuration Wizard 

Error Message

Event ID: 13360
Category: Storage Management
Description: An error was detected while accessing the Vault Database 'EVDATABASE' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand)

Description:The user does not have permission to perform this action.

SQL Command: usps_GetTransactionLogSize
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e14
SQL State: 42000
Native Error: 00000297
HRESULT 0x80040e14


By default the VSA will not have access to certain procedures that query meta data on the SQL Server where the EV Directory and Vault Store databases reside.


Modify the permissions of the VSA via the Microsoft SQL Server Management Studio (SSMS) to grant VIEW SERVER STATE.

1. Login to the SQL Server and Open the SSMS
2. Right click on the 'server name' and choose properties
3. In the left hand pane choose Permissions
4. In the right hand pane scroll to the VSA
5. Below the user accounts choose the tab Effective
6. Ensure VIEW SERVER STATE is present
7. If not, grant VIEW SERVER STATE
    a. Choose the Explicit tab and Grant the VIEW SERVER STATE permission
    b. Choose OK, changes are immediate
8. Re-run all checks in Vault Admin Console

Note: The permissions can be granted via query using the following statement.  Be sure to execute this statement under the master database.


More information regarding this can be found at http://msdn2.microsoft.com/en-us/library/ms189768.aspx

Terms of use for this information are found in Legal Notices.



Did this article answer your question or resolve your issue?


Did this article save you the trouble of contacting technical support?


How can we make this article more helpful?

Email Address (Optional)