Posts Tagged ‘How to chnage system admin password in sql server 2005’

Hello Friends many People install sql server 2005 and then after they want to change system admin password mean “sa” password.

i give you two way to change “sa” password one is if you don`t know the password then do following stuff in your query window.
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
USE [master]
ALTER LOGIN [sa] WITH PASSWORD=N’NewPassword’

Second Way is you may be  remember your Old Password and want to change the ’sa’ password then do following stuff.

ALTER LOGIN [sa] WITH PASSWORD = N’MyNewPassword’ OLD_PASSWORD = ‘MyOldPassword’;

Enjoy Boys and Girls.