you don't need to know the old password.

i changed my sa pwd with this code:

and i was logged on with a windows account with the sysadmin server role.

defiant.

Yes, you are right, I just checked that.

Thanks for letting me know on this.


-Vijay G

Hii,
I tried this but could not work for me because my user is not the member of sysadmin so it does not allow me to do so.

Please guide me regarding this

You can reset the SQL log in password in two ways. If you are skilled SQL command, you can reset sa password with some simple codes like [osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"] . If you have no ideal about SQL command, I would like to recommend you to free download MS SQL Server Password Unlocker, which helps to instantly change SQL password without data loss.

Personally, I would like to use SQL password changing tool, like MS SQL Server Password Unlocker. I have no ideal about the sql commands and other setting but I forgot sql password. My friend recommended me MS SQL Server Password Unlocker, and I used it. Just one click, I reset the SA password

MS SQL Server Password Unlocker helps to reset sa password saved in master.mdf! I had forgotten the sa password last week, and I fortunately found the MS SQL Server Password Unlocker at a password recovery blog. There are many password recovery solutions including SQL password recovery.