To reset a SQL Server user password:
Log on as adminstrator on the pc with sql server, then open up SQL Server Management Studio Express.
Change Authentication to Windows and connect.
Under Security->Logins you should see "sa".
Open up the properties page and you should see the password fields to edit. |