• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL 2005 Server - sa password

R

rsutoratosu

Platinum Member
So is there any new way to retreive sa passwords ? have a db that was setup by someone long ago.. i can reset it since I can get in using windows authentication but i dont know how many other machines have odbc connections to it
 
i didn't use it, last person setup odbc connections did.. im debating should i take the time and fix it or just build a new sql server and move all the stuff over
 
I haven't had to do this (and I don't have an environment to test in at the moment) but based on a couple of articles/blog posts, it looks like you may be able to dump the hash and salt from sys.sql_logins and then use a tool to crack the hash.

If you suspect that he used a short password with a small character set (only letters, for example), then you've got a pretty damn good chance at cracking it. On the other hand, if he didn't, then you probably shouldn't waste your time.
 
You don't have to rebuild the server to change the sa password. Just run a trace to locate where the logins are coming from and fix the odbc settings.
 
not rebuilding server, moving stuff to sql 2008, but incase that doesn't work, ill need to put it back to the original 2005 server
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top