Solved

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

  • 29 March 2023
  • 17 replies
  • 1343 views

Userlevel 3
Badge +11

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

 


 

 

icon

Best answer by Scott Moseman 16 June 2023, 20:23

View original

17 replies

Userlevel 6
Badge +14

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

Userlevel 3
Badge +11

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

Userlevel 6
Badge +14

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

Userlevel 3
Badge +11

Hello,

@Scott Reynolds thank you for your email.

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

BR,
Elizabeta

Userlevel 6
Badge +14

@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

Userlevel 3
Badge +11

Hello,

I have succesufully conect to sql via Windows PowerShell.

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

Best regards,
Elizabeta

 

Userlevel 6
Badge +14

Hi,

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

Best Regards,

Sebastien Merluzzi

Userlevel 3
Badge +11

Hello,

Thank you @Sebastien Merluzzi !

Best regards,
Elizabeta

Userlevel 6
Badge +14

@elizabeta ,

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

Userlevel 3
Badge +11

Hello,

I have a question

Userlevel 6
Badge +14

@elizabeta 

Sure

Userlevel 3
Badge +11

For some reason I can not send reply on this post

There is a message Something´s gone wrong

Userlevel 6
Badge +14

@elizabeta 

well i did receive your last one 😀

Userlevel 3
Badge +11

When I wrote message and click sent  there is a message 

There is a message Something´s gone wrong

 
Userlevel 3
Badge +11

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

Userlevel 6
Badge +14

Why, can’t you change it?

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

Userlevel 6
Badge +17

You can find instructions online for resetting the “sa” password.  It’s a SQL Server process which you can perform outside the scope of Commvault.

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?view=sql-server-ver16

Thanks,
Scott
 

Reply