locked
Change password RRS feed

  • Question

  • After install SQL Server Express 2008, I want to change the user and password which it brings by default, how do I do that?
    Tuesday, November 25, 2014 7:31 PM

Answers

  • You can use ALTER LOGIN or in SSMS under Security click on logins, right click the login id and you will see where to change the password.

    Andy Tauber
    Data Architect
    The Vancouver Clinic
    Website | LinkedIn

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Tuesday, November 25, 2014 8:51 PM
  • If you don't have SSMS on your machine.

    Then you can set the password for Logins via SQLCMD.

    1. Open CMD prompt and Connect SQL Instance.

    sqlcmd –S SQLSERVER\INSTANCE

    2. once connect, choose name from syslogins.

    select name from syslogins;
    GO


    3. Now change the password for whichever user you want.

    ALTER LOGIN sa WITH PASSWORD = 'newpassword', check_policy =OFF
    go


    Wednesday, November 26, 2014 6:43 AM
  • and password which it brings by default

    There is no "default password", you have to assign a password for the "sa" account during Installation.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, November 26, 2014 7:19 AM
  • if you use windows authentication you do not need to have user and password for logging. The sql server accepts your current windows user.
    Wednesday, November 26, 2014 9:49 AM

All replies

  • You can use ALTER LOGIN or in SSMS under Security click on logins, right click the login id and you will see where to change the password.

    Andy Tauber
    Data Architect
    The Vancouver Clinic
    Website | LinkedIn

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Tuesday, November 25, 2014 8:51 PM
  • If you don't have SSMS on your machine.

    Then you can set the password for Logins via SQLCMD.

    1. Open CMD prompt and Connect SQL Instance.

    sqlcmd –S SQLSERVER\INSTANCE

    2. once connect, choose name from syslogins.

    select name from syslogins;
    GO


    3. Now change the password for whichever user you want.

    ALTER LOGIN sa WITH PASSWORD = 'newpassword', check_policy =OFF
    go


    Wednesday, November 26, 2014 6:43 AM
  • and password which it brings by default

    There is no "default password", you have to assign a password for the "sa" account during Installation.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, November 26, 2014 7:19 AM
  • if you use windows authentication you do not need to have user and password for logging. The sql server accepts your current windows user.
    Wednesday, November 26, 2014 9:49 AM
  • once you set SQL server authentication during installation , can able to reset your sa password. By logging with windows authentication.

    Regards, Muthukumar Balu

    Wednesday, November 26, 2014 10:18 AM
  • try this :

    http://duhjones.com/how-to-reset-lost-sa-password-in-sql-express/

    OR THIS

    You need to follow the steps described in Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out and add your own Windows user as a member of sysadmin:

    • shutdown MSSQL$EXPRESS service (or whatever the name of your SQL Express service is)
    • start add the -m and -f startup parameters (or you can start sqlservr.exe -c -sEXPRESS -m -f from console)
    • connect to DAC: sqlcmd -E -A -S .\EXPRESS or from SSMS use admin:.\EXPRESS
    • run create login [machinename\username] from windows to create your Windows login in SQL
    • run sp_addsrvrolemember 'machinename\username', 'sysadmin'; to make urself sysadmin member
    • restart service w/o the -m -f

    • Proposed as answer by Ismaiel AKKA Thursday, November 27, 2014 2:41 PM
    Thursday, November 27, 2014 2:41 PM
  • OR Try this :

    http://www.bitdefender.com/support/how-to-reset-sql-server-sa-password-using-microsoft-sql-server-management-studio-express-787.html

    • Proposed as answer by Ismaiel AKKA Thursday, November 27, 2014 2:43 PM
    Thursday, November 27, 2014 2:43 PM