Reset Sysman password

[DreddMetal]

Hi all,

 

I know there is a way to reset the SIMS .Net sysman password, using osql if i remember rightly, sadly thats all i can remember, could someone please post the command required to reset the sysman account password?

 

Thanks in advance

[ravens]

Hi,

 

try this:

 

osql -Sserver\sims2005 -E -n -Q"exec sims.sims.db_p_reset_sysman_password"

 

Dont know what it resets the password to though. Maybe you could tell me if you find out.

 

Thanks

[matt40k]

Resets the sysman password to password.

[ravens]

So it does. Thanks

[Steve_T]

To reset the SYSMAN password from the command prompt:

Login via OSQL as above: OSQL -E -S 127.0.0.1\SIMS

Then, do the following:

1> use sims

2> go

1> exec sims.db_p_reset_sysman_password

2> go

(1 row affected)

1> exit

[Oops_my_bad]

Here's a utility I came across when doing a server move a few weeks back. As long as you know the SA password for your SQL instance, this tool will let you reset the sysman passwords for both sims and FMS

 

I don't think there's any issue with posting it here, it's freely available if you know where to look. Don't forget to do a full backup before you use it, caveat emptor.. etc.. etc..

ESSUpgrade.zip

[matt40k]

Interesting...

[lukepollard]

Having moved out Hosted SIMS to Arbor MIS now, I have never had to install any of the SIMS database/FMS client before as it was entirely hosted.

 

Unfortunately our finance team needed to fire up the backup of FMS for a incorrect VAT claim and good grief how hideous it was trying to work out how to install FMS with no instructions. Finally after trawling many forums, bashing my head against every error message, manually finding and installing BDE, FMS, Messing with ini configs, Installing 2005 SQL native.. we have ourselves a working FMS on one of our VMs. Certainly a blast from the hideous past!

 

I just wanted to say thanks to Oops_my_bad (some 11 years later) for the tools that allowed us to reset the password and finally get into this hunk of junk software.

[mavhc]

Keep a few VM backups around of stuff for times like those

[richmackie]

I can confirm that in 2023 this still works.

[Koldov]

I can confirm that in 2023 this still works.

 

Why wouldn't it?

 

SIMS doesn't look or feel like it's had any major update since about 1994 (and it probably hasn't), so it will possibly still work in another 15 years...

 

Edited June 30, 2023 by Koldov

[richmackie]

I know one headteacher who definitely sees that as a good thing...

[mavhc]

As long as you don't connect the computer it's running on to any network