Windows/mssql
Aus SchnallIchNet
< Windows
Reset lost sa password
- Stop the service 'SQL Server (SQLEXPRESS)'
- Open properties of 'SQL Server (SQLEXPRESS)'
- Enter '-m' into the 'Start parameters' field.
- Start the service 'SQL Server (SQLEXPRESS)'
- open CMD
- Enter following command sequence:
osql -S PC_NAME\SQLEXPRESS -E 1> alter login sa enable 2> go 1> sp_password NULL,'new_password','sa' 2> go 1> quit
- Stop the service 'SQL Server (SQLEXPRESS)'
- Remove '-m' from the 'Start parameters' field.
- Start the service 'SQL Server (SQLEXPRESS)'