commvault.com commvault.com
Question

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

  • 29 March 2023
  • 5 replies
  • 130 views
E
Rank
Userlevel 2
Badge +10

Hello,

I have Windows 2012 R2 Standard, Microsoft SQL Server 2012, and CommServe simpana 11.2.85.

I forgot  'sa' user password for SQL , how can I connect to mysql?
 

How to reset that password?

Best regards,
Elizabeta

 


 

 

5 replies

S
Rank
Userlevel 6
Badge +12

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

E
Rank
Userlevel 2
Badge +10

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

S
Rank
Userlevel 6
Badge +13

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

E
Rank
Userlevel 2
Badge +10

Hello,

@Scott Reynolds thank you for your email.

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

BR,
Elizabeta

S
Rank
Userlevel 6
Badge +12

@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

Reply


Terms & ConditionsCookie settings