Reset password for MSSQL

If you are using RHEV Manager, you’ll have a whole headache of Windows 2008 and 2008 SQL Server crap. After an upgrade, we realized that we did not have the SQL server account password used. Redhat told us:

To recovery of sql server sa password should be easy by using the local windows administrator credentials to login and set the sa password.

sqlcmd -S .\sqlexpress -drhevm -Q "ALTER LOGIN sa WITH PASSWORD = 'new_password'"