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..

[matt40k]

Interesting...