forgot sa password for sqlexpress

Failed to create Java Virtual Machine. - Eclipse- android

super pachchi

testblog

Azure migration- considerations

Code quality: Is my build Better than last Build

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




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




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




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