Skip to main content
Solved

MSSQL Failed to verify

  • December 14, 2022
  • 5 replies
  • 941 views

Forum|alt.badge.img+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?

 

Best answer by Scott Reynolds

@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.

View original
Did this answer your question?

5 replies

Forum|alt.badge.img+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.


Forum|alt.badge.img+8
  • Author
  • Byte
  • 42 replies
  • December 15, 2022

@Scott Reynolds 

Then should I make a Windows account? not mssql account


Forum|alt.badge.img+5

Hi Chris,

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


Forum|alt.badge.img+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.


Forum|alt.badge.img+14

@chris_ahn 

Did you get this issue sorted out?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings