Changing password on SQL Express 2008

1149565 pts.
Tags:
SQL Express
SQL Server
I recently installed SQL Server Express 2008 and I'm signing in using Windows authentication. But after that, I can't do anything. Is there a way I can change the password so I can have access? I'm also using Windows 7.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are several ways to change SA password,by using SQL Server Management Studio, SQL script or third-party software. Check out this tutorial for detailed steps. I hope this will be helpful for you.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What can't you access? Are you getting any error messages?
    134,635 pointsBadges:
    report
  • geemamoore

    I follow these two into one section because the commands for them are entered at the same place.

    1. Open the Services applet in the Control Panel
    2. Find the “SQL Server (SQLEXPRESS)” entry and open its properties
    3. Stop the service
    4. Enter “-m” into the “Start parameters” field
    5. Start the service
    6. Open a Command Prompt
    7. Enter the command:

    1. osql -S PC_NAME\SQLEXPRESS -E

    Be sure to change PC_NAME to whatever your PC name is or you will get a big long message saying you messed up.

    8. At the next prompts enter the following commands:


    1> alter login sa enable

    2> go

    1> sp_password NULL,'new_password','sa'

    2> go

    1> quit

    9.Stop the “SQL Server (SQLEXPRESS)” service

    10.Remove the “-m” from the Start parameters field

    11.Start the service

    At this point you should be able to login to SSMS using the sa user account and the new password you gave it.

    These steps will help you to change your SQL server express 2008 password 

    365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: