Solutions for forgetting the SQL server password

See http://www.cnblogs.com/jiang_zheng/archive/2009/02/05/1384622.html

1 ==========

In the CMD window

C: \ Documents ents and Settings \ Administrator> osql-e

1> sp_password null, 'abc123', 'sa'

2> go

Password Changed.
1> exit

As a result, the SA password is changed to ABC123.

The key is osql this stuff, specific view http://msdn.microsoft.com/zh-cn/vstudio/ms162806.aspx

2 ========

C: \ Documents ents and Settings \ Administrator> osql-e
1> exec sp_addlogin WC, WC
2> go
You have created a new logon.
1> exec SP_ADDSRVROLEMEMBER 'wc ', 'sysadmin'
2> go
'Wc 'has been added to the role 'sysadmin.
1> quit