sa Password recovery

[jonlake]

We have a Microsoft Server running Microsoft SQL Server 2000. It is a domain member and I have domain access rights. Anyone that may have known this password has left the company. I would like to know if there is a way to recover the sa password. I have physical access to the box, so that isn't a problem. I have done some searching and haven't found anything. If someone could point me in the right direction I would appreciate it.

Thanks,

Jon

 

[mrdenny]

There are password crackers out there. You can find them on google. However odds are no one on the forums will give you any key-words or URLs to find them. We can never be sure that your intentions are good.

That said, monitor the SQL Server using profiler for a couple of weeks. If no one ever logs in with the sa account then you should be able to safely change the password.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[jonlake]

Yea, thats understandable. I'm well aware of the password crackers, just unsure if there is a password recovery technique like in mysql and linux. I've asked around work to see if this was setup by our database team and if there is a standard sa password. There are two databases, worse comes to worse, we can use a different database for the one application im trying to get at.

 

[mrdenny]

Nope, there's no password recovery.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com