Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Accounts Password Recovery

Author  Topic 

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2006-08-10 : 20:07:29
Hello folks -
One of my team's member left the company a few months ago taking with him most of of our sql accounts passwords and as we develop new processes we need those accounts and passwords and instead we keep creating new acounts, which I believe is not healthy for the security of the system.
Question: Are there any safe tools out there that allows DBAs to crack/recover SQL accounts passwords ?

Once again, thanks in advance for the help.


---

Thanks!
Igor.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-08-10 : 21:00:20
Why don't you just change the passwords?

If you are in the sysadmin server role, you can change any SQL Server password without knowing the password.



CODO ERGO SUM
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-08-11 : 11:56:50
if this is in production, you should have control on who has knowledge of the passwords, usually DBA or operations support, which helps you prevent the scenario you just mentioned

if you can't practice this, then changing the password will likely be to your advantage for security reasons

--------------------
keeping it simple...
Go to Top of Page

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2006-08-11 : 12:23:40
well... we're a small group in our company, not like we have all these groups to support us, our company uses mainframe and oracle to store data, lotus notes as application and data entry and our group uses sql server for reporting and data analysis. my fear is that if I change passwords, processes all over the place will break, like reports in reporting services and dts packages...


---

Thanks!
Igor.
Go to Top of Page
   

- Advertisement -