forgot sa password for sqlexpress

Musings Public · Protected · Private

Type: Public | Created: 2014-11-05 | Frozen: Yes

« Previous Public Blog Next Public Blog »

Comments

Three steps to reset is
1) first bring the login method to mixed mode
2) Fix password
Enable sa useraccount
reset the password
1) using regedit, change the following
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.10.SQLEXPRESS\MSSQLServer
- LoginMode from 1 to 2
2) Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: before restarting Enter “-m” into the “Start parameters” field
-- You are doing this in "control panel" - > admin tools -> services

while sql express service is running in this mode
Do following steps in commandline...
osql -S YOURCOMPUTERNAME\SQLEXPRESS -E
1> alter login sa enable 2> go
1> sp_password NULL,'MYNEWPASSWORD','sa'
2> go
1> quit

Thats it
Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: remove “-m” in “Start parameters” field

Login with your new password
2014-11-05 15:15
Three steps to reset is
1) first bring the login method to mixed mode
2) Fix password
Enable sa useraccount
reset the password
1) using regedit, change the following
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.10.SQLEXPRESS\MSSQLServer
- LoginMode from 1 to 2
2) Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: before restarting Enter “-m” into the “Start parameters” field
-- You are doing this in "control panel" - > admin tools -> services

while sql express service is running in this mode
Do following steps in commandline...
osql -S YOURCOMPUTERNAME\SQLEXPRESS -E
1> alter login sa enable 2> go
1> sp_password NULL,'MYNEWPASSWORD','sa'
2> go
1> quit

Thats it
Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: remove “-m” in “Start parameters” field

Login with your new password
2014-11-05 15:15
Three steps to reset is
1) first bring the login method to mixed mode
2) Fix password
Enable sa useraccount
reset the password
1) using regedit, change the following
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.10.SQLEXPRESS\MSSQLServer
- LoginMode from 1 to 2
2) Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: before restarting Enter “-m” into the “Start parameters” field
-- You are doing this in "control panel" - > admin tools -> services

while sql express service is running in this mode
Do following steps in commandline...
osql -S YOURCOMPUTERNAME\SQLEXPRESS -E
1> alter login sa enable 2> go
1> sp_password NULL,'MYNEWPASSWORD','sa'
2> go
1> quit

Thats it
Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: remove “-m” in “Start parameters” field

Login with your new password
2014-11-05 15:15
Three steps to reset is
1) first bring the login method to mixed mode
2) Fix password
Enable sa useraccount
reset the password
1) using regedit, change the following
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.10.SQLEXPRESS\MSSQLServer
- LoginMode from 1 to 2
2) Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: before restarting Enter “-m” into the “Start parameters” field
-- You are doing this in "control panel" - > admin tools -> services

while sql express service is running in this mode
Do following steps in commandline...
osql -S YOURCOMPUTERNAME\SQLEXPRESS -E
1> alter login sa enable 2> go
1> sp_password NULL,'MYNEWPASSWORD','sa'
2> go
1> quit

Thats it
Stop and restart the “SQL Server (SQLEXPRESS)” service.
--Note: remove “-m” in “Start parameters” field

Login with your new password
2014-11-05 15:15

This blog is frozen. No new comments or edits allowed.