- Open the Services application and look for SQL Server (SQLEXPRESS).
- Stop the SQL Server (SQLExpress) service.
- Right-click the SQL Server (SQLExpress) service and select Properties.
- At the Start parameters field type in -m.
- Click the Start button.
- Close the Services application.
- Open a Command Prompt in elevated mode.
- Execute the following command:
osql -S <LOCAL_PC_NAME>\SQLEXPRESS -E
Note: The <LOCAL_PC_NAME> must be changed appropriately.
- At the prompt generated by the previous command invoke the following commands in sequence:
sp_password NULL,'<NEW_PASSWORD>','sa'
Note: Change <NEW_PASSWORD> to your desired password.
go
quit
- Close the elevated Command Prompt.
- Repeat steps 1 to 6, but on step 4 remove -m from the Start parameters field, if it exists.
Leave a Reply