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.
Tags: Change "sa" Password in sql sereve 2005, How to chnage system admin password in sql server 2005
This entry was posted
on Wednesday, October 8th, 2008 at 1:55 am and is filed under Sql Server.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
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
Leave a reply