+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, Sims.net... before I go and look stupid on the Capita forum in Technical; Guess who has "lost" the SQL password for SIMS (on our system: user = sa)? Guess who swears that he ...
  1. #1

    Join Date
    Oct 2005
    Location
    Anywhere but in a school ;o)
    Posts
    522
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Sims.net... before I go and look stupid on the Capita forum

    Guess who has "lost" the SQL password for SIMS
    (on our system: user = sa)?

    Guess who swears that he told me it, and swears that I've written it down (if I had - I would've made an electronic copy or emailed it to him, and I haven't).

    Guess who is having a paddy in the office right now and pointing the finger at me...

    ... and guess who is trying to find it and calm him down? *sigh*

    Is he stuffed if he's really forgotten it? Can it be retrieved?

  2. #2
    Guest

    Re: Sims.net... before I go and look stupid on the Capita fo

    Hiya do you know if it has been changed by "BOSSMAN" since I left?

  3. #3

    Join Date
    Oct 2005
    Location
    Anywhere but in a school ;o)
    Posts
    522
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Sims.net... before I go and look stupid on the Capita forum

    I don't think it has - I wondered if you'd remember it... but then it was a long time ago.

    I'll (no, actually HE'll) owe you a pint if you remember it... PM me!

  4. #4

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Sims.net... before I go and look stupid on the Capita forum

    The MS SQL event log (assuming you have auditing enabled) should reveal when/who changed the password.

    To reset the sa password, you can do the following:

    1. Login to the SQL Server box as the Administrator.
    2. Run SQL Server Enterprise Manager.
    3. Right-click the server name and choose 'Edit SQL Server Registration properties'.
    4. Choose 'Use Windows authentication' and click OK button.
    5. Expand a server, expand a Security and click Logins.
    6. Double-click the sa login and specify new password on the General tab.

    I've no idea if this will break Sims.Net though.

  5. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,400
    Thank Post
    636
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: Sims.net... before I go and look stupid on the Capita forum

    Who = your apparently, according to your blog, incompetent boss?

  6. #6

    Join Date
    Oct 2005
    Location
    Anywhere but in a school ;o)
    Posts
    522
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Sims.net... before I go and look stupid on the Capita forum

    You really think that my "wonderful" boss would forget a thing like that...????

  7. #7

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,400
    Thank Post
    636
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: Sims.net... before I go and look stupid on the Capita fo

    Quote Originally Posted by indiegirl
    You really think that my "wonderful" boss would forget a thing like that...????
    ........ yes? 8)

  8. #8

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

    Re: Sims.net... before I go and look stupid on the Capita forum

    Quote Originally Posted by Geoff
    The MS SQL event log (assuming you have auditing enabled) should reveal when/who changed the password.

    To reset the sa password, you can do the following:

    1. Login to the SQL Server box as the Administrator.
    2. Run SQL Server Enterprise Manager.
    3. Right-click the server name and choose 'Edit SQL Server Registration properties'.
    4. Choose 'Use Windows authentication' and click OK button.
    5. Expand a server, expand a Security and click Logins.
    6. Double-click the sa login and specify new password on the General tab.

    I've no idea if this will break Sims.Net though.
    I think Geoff is right as Capita don't ask for an SA paasword when you send them your data. It is probably best check with them. If you are using integrated authentication you might be even luckier as this hould be either an admin account on the server or domain admin.

    Why do you need the SA password anway, IndieGirl?

  9. #9
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,227
    Thank Post
    50
    Thanked 271 Times in 209 Posts
    Blog Entries
    6
    Rep Power
    108

    Re: Sims.net... before I go and look stupid on the Capita forum

    Indiegirl, I've sent you a PM

  10. #10


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,619
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223

    Re: Sims.net... before I go and look stupid on the Capita fo

    posting this from home, so check before you try it.

    IIRC, there's a .exe in \path\to\sql\bin folder called ChangeSAPW.exe (or similar) - does what it says on the tin providing you have local or domain admin rights on the server in question. You don't need to provide the old password to use it.

  11. #11

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

    Re: Sims.net... before I go and look stupid on the Capita fo

    Quote Originally Posted by pete
    IIRC, there's a .exe in \path\to\sql\bin folder called ChangeSAPW.exe (or similar) - does what it says on the tin providing you have local or domain admin rights on the server in question. You don't need to provide the old password to use it.
    This proabably does the same thing as what Geoff suggested but for people using MSDE where there is no Enterprise Management Console.

    Then again if IG's blog is to be believed it wouldn't be surprising if MSDE was the preferred option

  12. #12


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,619
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223

    Re: Sims.net... before I go and look stupid on the Capita fo

    @Network Geezer

    well, we're still using MSDE. We've only had <5 users of SIMS until recently and we're moving to sql server for electronic registration but up until now we haven't had a reason to change.

    ..... and when you inherit a ~6yr old sims installation with undocumented and long-forgotten hacks you do not touch it unless you need to.

  13. #13

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

    Re: Sims.net... before I go and look stupid on the Capita fo

    Quote Originally Posted by pete
    @Network Geezer
    ..... and when you inherit a ~6yr old sims installation with undocumented and long-forgotten hacks you do not touch it unless you need to.
    There is some mileage in "If aint broke don't fix" but for DR you should be able to regenerate the system from backups of the L/.MDF and S:\SIMS.

  14. #14


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,619
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223

    Re: Sims.net... before I go and look stupid on the Capita fo

    @network geezer
    yeah, I know. I've swapped the install to newer hardware (& from NT4 to 2003) and the dotNet / sql stuff has been done by me. It's the leftover stuff from pre dotNet days that occasionally rears its head and bites us.

    If I had to I could easily rebuild it from scratch (we've done test builds on random hardware). I haven't because I'm only 75% certain that we no longer need the hacked-together stuff and it isn't causing us any real harm atm.

  15. #15
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,227
    Thank Post
    50
    Thanked 271 Times in 209 Posts
    Blog Entries
    6
    Rep Power
    108

    Re: Sims.net... before I go and look stupid on the Capita fo

    Quote Originally Posted by NetworkGeezer
    Quote Originally Posted by pete
    IIRC, there's a .exe in \path\to\sql\bin folder called ChangeSAPW.exe (or similar) - does what it says on the tin providing you have local or domain admin rights on the server in question. You don't need to provide the old password to use it.
    This proabably does the same thing as what Geoff suggested but for people using MSDE where there is no Enterprise Management Console.

    Then again if IG's blog is to be believed it wouldn't be surprising if MSDE was the preferred option
    If you're using MSDE with no Enterprise Manager, The Microsoft SQL Management Studio Express is your friend

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

Similar Threads

  1. Replies: 3
    Last Post: 29th June 2012, 01:22 PM
  2. [SIMS] SIMS.net and multiple connect.ini files
    By NortyUK in forum MIS Systems
    Replies: 23
    Last Post: 9th September 2011, 12:05 PM
  3. [SIMS] sql 2008 Sp1 and Sp2 (Sims .net)
    By irsprint84 in forum MIS Systems
    Replies: 2
    Last Post: 22nd December 2010, 11:38 AM
  4. [SIMS] SIMS .net and FMSSQL Autumn 2010 released!
    By matt40k in forum MIS Systems
    Replies: 5
    Last Post: 24th November 2010, 10:14 PM
  5. Replies: 0
    Last Post: 17th September 2008, 09:52 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
  •