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
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
SQL State: 42000
Native Error: 00000297
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.
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.
GRANT VIEW SERVER STATE TO "DOMAIN\VSA"
More information regarding this can be found at http://msdn2.microsoft.com/en-us/library/ms189768.aspx