+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Reset Sysman password in Technical; Hi all, I know there is a way to reset the SIMS .Net sysman password, using osql if i remember ...
  1. #1
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    15

    Reset Sysman password

    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

  2. #2
    ravens's Avatar
    Join Date
    Oct 2007
    Location
    Barnet
    Posts
    39
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Resets the sysman password to password.

  4. #4
    ravens's Avatar
    Join Date
    Oct 2007
    Location
    Barnet
    Posts
    39
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    So it does. Thanks

  5. #5

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    12
    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

  6. #6
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Thumbs up

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

  7. Thanks to Oops_my_bad from:

    mortstar (15th April 2013)

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Interesting...

SHARE:
+ Post New Thread

Similar Threads

  1. Self Service Password Reset
    By plexer in forum EduGeek Self Service Password Reset
    Replies: 273
    Last Post: 5th November 2013, 06:51 PM
  2. bulk password reset
    By Jonny_sims in forum Windows
    Replies: 10
    Last Post: 26th September 2011, 10:12 PM
  3. Specops Password Reset
    By linkazoid in forum Windows
    Replies: 7
    Last Post: 16th May 2008, 02:27 PM
  4. reset admin password
    By fafster in forum Windows
    Replies: 11
    Last Post: 27th February 2008, 10:01 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •