+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
MIS Systems Thread, Sims.net... before I go and look stupid on the Capita forum in Technical; Originally Posted by Geoff The MS SQL event log (assuming you have auditing enabled) should reveal when/who changed the password. ...
  1. #16
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    Quote Originally Posted by Geoff View Post
    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.

    Sorry to bump an age old thread, but I need to have my sa password to migrate the database to a new machine, inherited the system so no idea what it is. I tried the above method and I get an error saying password change failed because either the account does not exist or I do not have permission. I'm logged onto the machine as administrator.

    Any ideas?

  2. #17
    rad
    rad is offline
    rad's Avatar
    Join Date
    Jan 2009
    Location
    Middlesex
    Posts
    2,502
    Thank Post
    337
    Thanked 310 Times in 238 Posts
    Rep Power
    110
    You can reset the password via a cmd prompt. We had it reset by the LEA so might be worth speaking to them.

  3. Thanks to rad from:

    quietriot1983 (21st May 2013)

  4. #18

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    you could try the changesapwd executable mentioned but you'll probably run into the same permissions problem.
    i'm not sure, but i think it's possible to have windows authentication setup so that a user other than administrator has admin rights, BUT, the actual administrator account doesn't. If this is the case you could try an old user's account - longshot i know.

    on the other hand, what type of migration are you doing? if you have a .bak backup file of teh DB you can just create a new SQL server, choose your own SA password and restore using dbattach. Even if you have the mdf/ldf you can copy them to new server and dbattach.

  5. Thanks to vikpaw from:

    quietriot1983 (21st May 2013)

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

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
  •