Solved

Live sync Log Failover logshipping SQL error 30:436

  • 9 March 2021
  • 6 replies
  • 1980 views

Userlevel 4
Badge +14

Hello,

On a fresh installed LAB, I am trying to test my failover

 

I have followed this r good detailed procedure.

https://documentation.commvault.com/commvault/v11/article?p=102845.htm

 

I got an error message in the job controller when the cv failover logshipping start.

Error Code: [30:436] Description: Instance validation failed: Insufficient SQL Server role. To configure the instance, the user must be a member of the SYSADMIN SQL server role. Source: commserve, Process: JobManager 

 

which user should have the sysadmin rights ?

on the SQL management studio,

sqladmin_cv has sysadmin role and sqlexec_cv has only public

 

 

Thanks !

icon

Best answer by Mike Struening RETIRED 9 March 2021, 17:05

View original

6 replies

Userlevel 3
Badge +8

Hi,

Did you also check the database on the Standby CommServe?

__

Jeremy

Userlevel 4
Badge +14

Hi @Jeremy,

Yes it is exactly the same config on the standby Commserve.

 

Userlevel 7
Badge +23

 

Userlevel 4
Badge +14

Hi @Mike Struening,

Thanks for your help.

On the two commserves PROD and standby, the NT AUTORITY\SYSTEM has the sysadmin role

here is the exact error message.

 

Userlevel 7
Badge +23

@Bloopa is there any chance you have another account specified?

https://documentation.commvault.com/commvault/v11_sp20/article?p=18204.htm

Userlevel 4
Badge +14

Thanks to all. 

On each instance I had to specify this.

 

Reply