cancel
Showing results for 
Search instead for 
Did you mean: 

EV Operations Manager configuration error - SQL questions

goatboy
Level 6

Hi

Environment is EV 10.0.3

Getting this error when running Operations Manager configuration wizard:

'Invalid user, please specify valid credentials of the monitoring user'

Same issue here: http://www.symantec.com/connect/forums/how-scuccessfully-installconfigure-operations-manager

EV10 guide says this needs to be done:

Creating EVMonitoringOperator in the msdb system database and

assigning Vault Service account

Use this procedure to:

Create the EVMonitoringOperator role in the msdb system database

Assign the Vault Service account to the EVMonitoringOperator role

To create the EVMonitoringOperator role and assign Vault Service account

1 Connect to the SQL server using SQL Server Management Studio.

2 Click New Query and enter the query in the query editor window.

USE MSDB

GO

CREATE ROLE EVMonitoringOperator AUTHORIZATION dbo

exec sp_addrolemember SQLAgentUserRole, EVMonitoringOperator

GRANT SELECT ON sysjobs TO EVMonitoringOperator

GRANT SELECT ON sysjobschedules TO EVMonitoringOperator

GRANT SELECT ON sysjobsteps TO EVMonitoringOperator

GRANT SELECT ON sysjobservers TO EVMonitoringOperator

EXEC sp_addrolemember N'EVMonitoringOperator', N'domain\vsa'

GO

where domain\vsa is the Vault Service account and the domain it belongs to.

3 From the Query menu, click Execute, and wait for the script to complete.

Do I need to do this for the VSA, or for the AD account I have set up specifically for Operations Manager?  http://www.symantec.com/business/support/index?page=content&id=TECH76700 says just to use a normal AD user account.

 

thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

this would be for the account you setup for monitoring. the VSA already has all the necessary permissions.

View solution in original post

2 REPLIES 2

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

this would be for the account you setup for monitoring. the VSA already has all the necessary permissions.

goatboy
Level 6

Thanks very much