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.
| Author |
Topic |
|
jperl
Starting Member
3 Posts |
 Posted - 2006-03-16 : 16:39:49
|
| We have Ipswitch's 'What's UP' and a WSUS server running and I was recently asked to admin these since I have experience with MySQL, potentially being the only one with previous SQL experience, and they run on MS SQL. Unfortuantely no one knows the admin passwords used to access them. Since their install, no one has tried to access the databases. This creates a problem for me because one of the things I was asked to do was create a script that will have the What's UP auto-discovery of new computers add the computers to WSUS and remove old ones that have been removed from the network. Unforutnately this means I need to log in and see what the two databases look like, later actually reading data from one to adjust the other.Does anyone know any way to find out the passwords without resetting them and breaking the current running programs?I tried to use the enterprise manager as suggested by MS SQL City.com, but could not find the manger.I am not entirely sure what parts are installed. My understanding is that I only have the engines for What'sUP and WSUS installed because they were installed with the program.Thank you in advance for your time and help. Right now all I'm sure of is that it's needed so that I can clean up the mess handed to me. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-16 : 20:30:52
|
just to have someone reply to your post...i don't know if anyone here will offer any method on how to retrieve the passwords, it's breaking securitythe usual suggestion is to change the password, since you do not have that option i suggest you use google to get the answer you need  good luck--------------------keeping it simple... |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-17 : 09:20:23
|
| If the server was set up with mixed security, you can logon as a member of the Adminstrators local group and reset the SA password. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-17 : 09:21:13
|
| Oh, you can't reset them without breaking the application?That sucks, dude. You are screwed. Sorry. |
|
|
|
jperl
Starting Member
3 Posts |
Posted - 2006-03-17 : 12:00:34
|
quote:
Originally posted by blindman
Oh, you can't reset them without breaking the application?That sucks, dude. You are screwed. Sorry.
i was thinking this would be the case.and jen, i have been googling but i cant find the solution. decrypting the pwd file seems to be the only thing i can think of, but that'll take some horse power and time if M$ has anything resembling security |
|
|
|
|
|
|
|
|
MS SQL lost Admin password