+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
MIS Systems Thread, sql server sims sa password in Technical; you can uninstall the MSDBE and reinstall it (there is a knowledge base article on it) Re-set up the engine, ...
  1. #16
    StewartKnight's Avatar
    Join Date
    Jun 2005
    Posts
    1,587
    Thank Post
    2
    Thanked 27 Times in 21 Posts
    Rep Power
    31

    Re: sql server sims sa password

    you can uninstall the MSDBE and reinstall it (there is a knowledge base article on it)

    Re-set up the engine, changing the password to whatever you want, log in again as sa!

    It only takes a couple of minutes to uninstall / install.

  2. #17

    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 StewartKnight
    you can uninstall the MSDBE and reinstall it (there is a knowledge base article on it)

    Re-set up the engine, changing the password to whatever you want, log in again as sa!

    It only takes a couple of minutes to uninstall / install.
    Uraken has the full SQL Server 2000. That's not the kind of thing that you want to uninstall and reinstall unless it's an absolute last resort. You'd also have to be sure you don'r break any other apps that may be hanging from it.

    I think in this particular case either the Enterprise Manager or an quick SQL script (thanks AJBritton and jonno) should be used.

  3. #18

    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

    hi all i'm a bit lost with this post now. I now assume i can change the sa password with no knock effect to sims but whats the best way?

  4. #19

    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

    forget my last post and please except my apologies for being a numpty i just had a quick poke about sql server management came across the sa user right clicked changed the password job's a gud un, good job i only spen ttwo months on this problem then lol



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

Similar Threads

  1. Rename SIMS server
    By cookie_monster in forum MIS Systems
    Replies: 19
    Last Post: 18th November 2009, 05:33 PM
  2. SIMS Server
    By tech-man in forum MIS Systems
    Replies: 6
    Last Post: 1st August 2007, 10:49 AM
  3. SIMS & SQL Server
    By tscnmuk in forum MIS Systems
    Replies: 16
    Last Post: 20th July 2007, 01:58 PM
  4. New SIMS Server
    By GrumbleDook in forum MIS Systems
    Replies: 15
    Last Post: 4th April 2007, 12:29 AM
  5. Now they want my server root password.
    By tickmike in forum General Chat
    Replies: 29
    Last Post: 10th September 2006, 12:23 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
  •