Wednesday, 30 April 2014

SQL Server forgot password

SQL Server forgot password

I forgot my sql server password, now i want to reset.
We can reset without having old password
Open Command prompt
Use below commands..
osql-E -S .\SQLEXPRESS(Your SQL Server Name)
exec sp_password @new='Enternewpassword', @loginame='sa'
go
alter login sa enable
go
exit
Now using sa account with new password you can login to sql server