commvault.com commvault.com
Solved

MSSQL Failed to verify

  • 14 December 2022
  • 5 replies
  • 487 views
C
Rank
Userlevel 2
Badge +8

i try to insert [Impersonate User]

 

I checked user name, password, server roles.

 

but The same error is repeated

 

What sholud i do next step?

 

icon

Best answer by Scott Reynolds 14 December 2022, 12:58

View original

5 replies

S
Rank
Userlevel 6
Badge +14

@chris_ahn 

That account you have listed in the CV GUI is just the account name. Should be in format domain\user.

Account should be a domain account that is sysadmin and also an administrator in Windows.

Once that is entered correctly restart the Commvault services on the client machine.

If you do not need to use an account just select local system in Commvault and In SQL Management Studio grant NT AUTHORITY\SYSTEM sysadmin role.

C
Rank
Userlevel 2
Badge +8

@Scott Reynolds 

Then should I make a Windows account? not mssql account

R
Rank
Userlevel 1
Badge +5

Hi Chris,

It should be <domain_name>\backupuser. If it is in workgroyp, then .\backupser also works fine

S
Rank
Userlevel 6
Badge +14

@chris_ahn You can leverage domain account or as @Ramkumar Giridaran  mentioned .\user

If you need to leverage a user, otherwise use local system and just grant NT AUTHORITY\SYSTEM sysadmin role in SQL and no need to manage user accounts.

S
Rank
Userlevel 6
Badge +14

@chris_ahn 

Did you get this issue sorted out?

Reply


Terms & ConditionsCookie settings