Post reply

Forgot sa password and can not connect by Window Account!

  • January 13, 2010 at 9:06 pm

    #218218

    Hi all,

    I have a computer which had been installed from ghost file. So, in this computer has Sql server 2008 installed on it, but the problem is I don't have sa password.

    I used Window acc to connect to the server but the server keep response "Login failed for user [Window acc]..."

    I also look at registry and found that the login mode is 1, someone who installed the sql server had chosen Window authentication mode.

    In this case, are there something i can do to connect to the server? Or do i just install a fresh instance.

    Thanks and regards.

    Sol

  • January 13, 2010 at 9:59 pm

    #1103413

    How to Connect to a SQL 2005 Server When You Are Completely Locked Out

    http://www.sqlservercentral.com/Forums/Topic812701-471-1.aspx

  • January 15, 2010 at 2:35 am

    #1104098

    Thanks very much 😀

    It took me one day to search and I finally found the way out in here.

    Sol

  • January 15, 2010 at 8:09 pm

    #1104542

    sol-356065 (1/13/2010)

    Hi all,

    I have a computer which had been installed from ghost file. So, in this computer has Sql server 2008 installed on it, but the problem is I don't have sa password.

    I used Window acc to connect to the server but the server keep response "Login failed for user [Window acc]..."

    I also look at registry and found that the login mode is 1, someone who installed the sql server had chosen Window authentication mode.

    In this case, are there something i can do to connect to the server? Or do i just install a fresh instance.

    Thanks and regards.

    Sol

    Careful, Sol... depending on why you're doing this, you could be violating a license agreement.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply