MSSQLserver

I have lost my password to my SQL server can someone help me retrieve it or
should I delete this server and download a new one?Can you log in from the console or a domain admin account, using Windows
authentication, and change the password?
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"RonP" <RonP@.discussions.microsoft.com> wrote in message
news:7119DAA8-68B0-416D-A53E-9EE46856B5B7@.microsoft.com...
>I have lost my password to my SQL server can someone help me retrieve it or
> should I delete this server and download a new one?|||Look at this here if you are abel to change to mixed mode:
http://groups.google.de/group/comp.databases.ms-sqlserver/browse_frm/thread/3f6b23861fd54c77
Then change the password ( If you ment that you lost the password of
the sa ) within a sql statement like:
EXEC sp_password 'sa', 'newpassword'
HTH, Jens Suessmeyer