Change password

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?

Answer 1

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.

Answer 2

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

Answer 3

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]

Answer 4

if you use windows authentication you do not need to have user and password for logging. The sql server accepts your current windows user.

Answer 5

once you set SQL server authentication during installation , can able to reset your sa password. By logging with windows authentication.

---

Regards, Muthukumar Balu

Answer 6

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

Answer 7

OR Try this :

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