how to reset you sqlserver password

25 06 2009

hi anybody forget or lost sqlserver password, dont worry

follow these steps:-
1)open sql query analyzer
2)click on windows authentication
3)click connect
4)enter this command
sp_password null,’new password’,'username’

ex:-sp_password null,’hello’,’sa’

simple

now your password is reset now connect to sa user to this password

note:-if you are using vista open query analyzer ‘run as admin’