mcr at sandelman.ca
Tue, 14 Sep 2010
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'"
posted at: 12:02 | path: /virtualization | permanent link to this entry
