February 2, 2007 at 4:01 pm
I am pretty new to SQL, but I was wondering if their is a SQL Statement to retrieve the admin password?
Ben
February 2, 2007 at 4:32 pm
No.
You can try if there are any third party tools to crack...
MohammedU
Microsoft SQL Server MVP
February 2, 2007 at 4:51 pm
When the password is stored it's encrypted.
In 2000 you could sniff the network for connections using SQL authentication, isolate the conection information, run it through a little C utility (see an excellent book called The Database Hackers Handbook for the code) and get the password back. But that was pretty well documented and I'd assume MS fixed that in 2005, though I haven't really tried it. If you had a situation where the passwords were saved as part of connection information in someone's enterprise manager you could get it (though this practice is definitely not recommended, I saw it more than a few times).
If you're a member of the sysadmin group, you can change the sa password, though do so with caution.
February 22, 2007 at 3:00 pm
Can I ask why you want to get the admin password? Normally, the reason for a password it to keep the wrong people from accessing the data.
Steve
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply