Sql Server : Change Login Password or Forgot Password

when you forgot your sql server password or want to generate new password, in that case follow some steps:

1. Start Command Prompt
2. write:
         osql -E -S .\SQLEXPRESS(Server Name)          
         exec sp_password @new='changeme', @loginame='sa'
         go
         alter login sa enable
         go
         exit

Comments