+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, reset "SA" password in sims? in Technical; Can anyone remember how to reset the SA password in sims? I've done another one of their stupid database patches ...
  1. #1
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    4,002
    Thank Post
    983
    Thanked 477 Times in 398 Posts
    Blog Entries
    12
    Rep Power
    98

    reset "SA" password in sims?

    Can anyone remember how to reset the SA password in sims?

    I've done another one of their stupid database patches which errored out and now I cant login to sims, or get into dbattach to restore the backup.
    Last edited by zag; 3rd April 2008 at 06:00 PM.

  2. #2

    Join Date
    Oct 2007
    Posts
    4
    Thank Post
    0
    Thanked 3 Times in 1 Post
    Rep Power
    0

    Smile reset "SA" password in sims?

    osql -SSERVER\SIMSSQL2005 -E -n -Q"sp_password @old =null, @new= 'NewSAPassword1#' , @loginame = 'sa'"

    This command assumes that

    The server name is SERVER
    The instance name is SIMSSQL2005
    The sa username is sa
    The new sa password is NewSAPassword1#

    Hope this helps!

  3. 3 Thanks to JAYC:

    dhicks (1st July 2009), dwhyte85 (11th February 2010), zag (4th April 2008)

  4. #3
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    4,002
    Thank Post
    983
    Thanked 477 Times in 398 Posts
    Blog Entries
    12
    Rep Power
    98
    Thanks, but how do you run the command?

    Is it from a command prompt? Or some sql thingy?

    Just a bit of background, I'm getting an error 6 when trying to log into sims after a failed patch.

    When trying to run dbattach to restore the database its saying my SA password is wrong, even though I know its right

  5. #4


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,706
    Thank Post
    354
    Thanked 807 Times in 722 Posts
    Rep Power
    348
    Command line as long as your PATH is set correctly which it should be.

  6. Thanks to kmount from:

    zag (4th April 2008)

  7. #5
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104

    Thumbs up

    Hate kicking dead threads but you've just saved my life.

  8. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Since it's been revived, anyone reading may also like to refer to :

    sql server sims sa password

    note sa password is not a SIMS password but an SQL one.



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, 07:51 PM
  2. bulk password reset
    By Jonny_sims in forum Windows
    Replies: 10
    Last Post: 26th September 2011, 11:12 PM
  3. reset admin password
    By fafster in forum Windows
    Replies: 11
    Last Post: 27th February 2008, 11:01 AM
  4. Cisco Switch Password Reset
    By FN-GM in forum Wireless Networks
    Replies: 6
    Last Post: 10th October 2007, 10:15 AM
  5. HI-GRADE laptop password reset?
    By bishopsgarthstockton in forum Hardware
    Replies: 15
    Last Post: 28th August 2007, 09:50 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
  •