Change SA Password in SQL Server 2008
In this article I describe how to change the sa password in SQL Server.
In this article I describe how to change the sa password in SQL Server. There are two ways to change the sa 's password. One way is to change password through Management Studio Wizard and another is by SQL query.
Change password using SQL Statement
Type following syntax to change sa password:
alter login sa with
Change Password using Management Studio
Login into SQL Server 2008 using Windows Authentication
Open Object Explorer and expand Security folder. Now right-click on sa account and go to Properties.
Change SA password and confirm password. Click OK.
Now password is changed.