Site Maintenance this evening The site will be offline for hosting changes. Time TBC

+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
MIS Systems Thread, sql server sims sa password in Technical; Hi all i have lost my sa password, which up til now hasn't really caused me any problems but i'm ...
  1. #1

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    sql server sims sa password

    Hi all i have lost my sa password, which up til now hasn't really caused me any problems but i'm forever trying to force off users when doing sims updates and need to know this password, i'm aware that i could change it somewhere within sql but need to know of any knock effects to sims?

    can i safely change the password with no dramas or if it will cause loads of problems hoe can i find it out (i have full access to the server)

  2. #2

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sql server sims sa password

    I presume you have local administrator password for the server hosting the SQL server. Navigate to "E:\Program Files\Microsoft SQL Server\MSSQL$SIMS\BIN" and look for a program called ChSaPwd.exe

  3. #3

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sql server sims sa password

    Woops. It only allows you to change the passord if you know it.

    Erm... are you running MSDE or full MS SQL Server 2000?

  4. #4

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: sql server sims sa password

    full sql server

  5. #5

    Join Date
    Jan 2007
    Posts
    41
    Thank Post
    2
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sql server sims sa password

    I have created a special admin user for this. As an admin for the sql server you can create a user, then give that user full admin rights over the database. You don't have to disturb the original sa account.

    It works for me anyway.

    Best wishes

    Jay Rubinstein

  6. #6

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: sql server sims sa password

    ok this sounds god i will give it a go,incidentally do you use this account to do upgrades and force users off the system?

  7. #7
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    34

    Re: sql server sims sa password

    You can use the sp_password stored procedure to reset the SA password without knowing the original.

  8. #8
    StewartKnight's Avatar
    Join Date
    Jun 2005
    Posts
    1,587
    Thank Post
    2
    Thanked 27 Times in 21 Posts
    Rep Power
    30

    Re: sql server sims sa password

    I bet the sa password is blank or the name of the school anyway!

  9. #9

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sql server sims sa password

    Quote Originally Posted by Uraken
    full sql server
    Then you can reset the password using the SQL Server Enterprise Manager GUI tool. Drill down to the logins node for the server you managing:

    SIMS_server (should the one with white arrow in green circle) then Security then logins then right-click on sa
    Just put the desired password in the field labelled password.

    Quote Originally Posted by ajbritton
    You can use the sp_password stored procedure to reset the SA password without knowing the original.
    Hmm interesting. Can you post some example code. Thanks

  10. #10

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: sql server sims sa password

    have tried blank and password and all the usual ones no joy, if i do manage to reset, will it effect sims?

  11. #11

    Join Date
    Jan 2007
    Posts
    41
    Thank Post
    2
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sql server sims sa password

    Have you tried the school's number?

    If you can set up a different user with full rights, it can be used to force users off. I login to SOLUS with my usual rights, download the new stuff, then go into dbupgrade again as my usual self. When it tells me (and it always does) that there are users logged in, I use the new admin user to force the users off. It works for me.

  12. #12

    Join Date
    Feb 2007
    Location
    Norwich, Norfolk
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: sql server sims sa password

    Quote Originally Posted by NetworkGeezer
    Quote Originally Posted by ajbritton
    You can use the sp_password stored procedure to reset the SA password without knowing the original.
    Hmm interesting. Can you post some example code. Thanks
    Code:
    EXEC sp_password @new = 'newpassword', @loginame = 'sa';
    You need admin rights to do this obviously (simplest way is presumably via Windows authentication).

  13. #13

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sql server sims sa password

    Quote Originally Posted by Uraken
    have tried blank and password and all the usual ones no joy, if i do manage to reset, will it effect sims?
    I don't think so. The sa password is for the entire SQL Server RDBMS (Relational Database Management System) not the SIMS DB.

    That's why Capita don't don't ask for your sa password when they you send them your data. They can attach the SIMS database with sa password for their SQL Server.

  14. #14

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sql server sims sa password

    Quote Originally Posted by Jonno
    Code:
    EXEC sp_password @new = 'newpassword', @loginame = 'sa';
    You need admin rights to do this obviously (simplest way is presumably via Windows authentication).
    Is domain admin or server local admin rights enough and should hybrid authentication been enabled during MSDE setup?

  15. #15

    Join Date
    Feb 2007
    Location
    Norwich, Norfolk
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: sql server sims sa password

    Quote Originally Posted by NetworkGeezer
    Quote Originally Posted by Jonno
    Code:
    EXEC sp_password @new = 'newpassword', @loginame = 'sa';
    You need admin rights to do this obviously (simplest way is presumably via Windows authentication).
    Is domain admin or server local admin rights enough and should hybrid authentication been enabled during MSDE setup?
    I just tested it with server local admin rights, and it worked fine. The machine is a test box that's not on a domain, however, so your mileage may vary.

    Hybrid authentication should have been enabled during MSDE setup for you to be able to use Windows authentication. If not, if it's SQL Server 2005, you can enable it with SQL Server Management Studio; right-click the server, choose "Properties", click "Security" and choose "SQL Server and Windows Authentication mode."

    If you know the logon details for a member of the SQL 'sysadmin' group, you can use that instead.

    Hope that helps.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Rename SIMS server
    By cookie_monster in forum MIS Systems
    Replies: 19
    Last Post: 18th November 2009, 04:33 PM
  2. SIMS Server
    By tech-man in forum MIS Systems
    Replies: 6
    Last Post: 1st August 2007, 09:49 AM
  3. SIMS & SQL Server
    By tscnmuk in forum MIS Systems
    Replies: 16
    Last Post: 20th July 2007, 12:58 PM
  4. New SIMS Server
    By GrumbleDook in forum MIS Systems
    Replies: 15
    Last Post: 3rd April 2007, 11:29 PM
  5. Now they want my server root password.
    By tickmike in forum General Chat
    Replies: 29
    Last Post: 9th September 2006, 11:23 PM

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
  •