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'"
Syndicated 2010-09-14 12:02:00 (Updated 2010-09-26 23:11:41) from Michael's musings