How to reset 'sa' user password for SQL server?

Hi @elizabeta ,

Can you check our Documentation and confirm it helped:

https://documentation.commvault.com/2022e/expert/2515_upgrades_troubleshooting.html#b2586_upgrade_failed_due_to_incorrect_password_for_sql_server_sa_user

Best Regards,

Sebastien

Hello,

Thank you @Sebastien Merluzzi for your response.

I read the documentation from the link you sent, my problem is the wrong password during CommServe upgrade, I can not reset this password, because can not open Microsoft SQL Server Management Studio … When I try open Microsoft SQL Server Management Studio there is an error
Cannot find one or more components. Please reinstall the aplications.

BR,
Elizabeta

@elizabeta Sounds like MSSQL install never completed or something removed Management Studio.

Might be best to open a case and allow support to assist. They should also be able to help with access to the instance.

Hello,

@Scott Reynolds thank you for your email.

We will contact support and open the case.
Thank you all for your help!

BR,
Elizabeta

@elizabeta ,

You can also download the new installer for SSMS 2018 and install it.

Otherwise, log a case with Support and we will check for you.

Best Regards,

Sebastien

Hello,

I have succesufully conect to sql via Windows PowerShell.

Can I change the password for user "sa" there?

Best regards,
Elizabeta

Hi,

Yes you can change the sa password and make sure you save it somewhere safe.

Best Regards,

Sebastien Merluzzi

Hello,

Thank you @Sebastien Merluzzi !

Best regards,
Elizabeta

@elizabeta ,

All done, if so can you mark as solved please 😀

Hello,

I have a question

@elizabeta 

Sure

For some reason I can not send reply on this post

There is a message Something´s gone wrong

@elizabeta 

well i did receive your last one 😀

When I wrote message and click sent  there is a message 

Hello,

Password for “sa” user is needed for upgrade commvault (database migreation) on new hardware.
Shoud I need to open incident with commvault to assist us to change this password in the installation process? I have read that using sqladmin_cv account we can reset password for sa user.

BR

Why, can’t you change it?

sqladmin_cv is our Commvault Account so we can login if needed.