Posts Tagged ‘Change “sa” Password in sql sereve 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.