+ 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
    3,765
    Thank Post
    898
    Thanked 417 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    87

    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 05: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
    3,765
    Thank Post
    898
    Thanked 417 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    87
    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,691
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    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,219
    Thank Post
    159
    Thanked 147 Times in 132 Posts
    Rep Power
    103

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