Yes, if you want to hack it. You can retrieve the encrypted password
from the sysxlogins table from the master database. Then, there are
documents on the algorithm used to encrypt/decrypt the hash.

However, it is easier to move the master database to another
installation as a database with a different name--make sure it is the
same version, edition, and service pack and QFE level--set the password
on that sysxlogins to null, then detach and replace the database on the
original server. You should now be able to access the system and reset
the password.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: Aaron
[mailto:mssqldba-ezmlmshield-x50060513.[Email address protected]
Sent: Thursday, July 29, 2004 6:52 AM
To: LazyDBA Discussion
Subject: Retrieve Lost SA password

Is it possible to retrieve a lost SA password on a SQL 2000 Server?


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page