commvault.com commvault.com
Solved

Live sync Log Failover logshipping SQL error 30:436

  • 9 March 2021
  • 6 replies
  • 1913 views
B
Rank
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

J
Rank
Userlevel 3
Badge +7

Hi,

Did you also check the database on the Standby CommServe?

__

Jeremy

B
Rank
Userlevel 4
Badge +14

Hi @Jeremy,

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

 

Mike Struening RETIRED
Rank
Userlevel 7
Badge +23

 

https://www.linkedin.com/in/michael-struening
B
Rank
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.

 

Mike Struening RETIRED
Rank
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

https://www.linkedin.com/in/michael-struening
B
Rank
Userlevel 4
Badge +14

Thanks to all. 

On each instance I had to specify this.

 

Reply


Terms & ConditionsCookie settings