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.
Hello ! I am Arjun Jadeja a Software Engineer by Profession. You can contribute and I will distribute your ideas through this site. Thanks and Enjoy