Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    California
    Posts
    40

    Unanswered: change SA's password

    I've searched this forum and was surprised to not find this asked before - Is there any way to change SA's password (we have managed to lose it somehow)? And we do have physical access to our SQL Server of course...if that helps.

    thanks in advance,
    jamie

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I know that it has been asked (and answered) a few dozen times in the last year, but right now the forums are a bit confused... Apparently the server had a "melt down" over the weekend, and it isn't fully recovered yet.

    The short answer (assuming that your installation is at least vaguely standard) is to:

    1. Log onto the server as a Windows Administrator.
    2. Connect to SQL Server using Windows Authentication.
    3. Change the password for the sa login.

    -PatP

  3. #3
    Join Date
    Dec 2003
    Location
    California
    Posts
    40
    Alright, thanks. I'll try that out.

  4. #4
    Join Date
    Aug 2004
    Posts
    76
    Interesting post!!!

    But PatP i can understand your steps but got puzzled with you 3rd one - Change the password for the sa login

    How to do? Is there any command??

  5. #5
    Join Date
    Sep 2005
    Posts
    2
    You can use both - an Enterprise Manager application or sp_password procedure

    Hope thiw will help...
    Leonid Niraev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •