Change SA Password in SQL Server 2008
In this article I describe how to change the sa password in SQL Server.
Introduction
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
Password= 'wintellect'
old_password= 'wintellect'
go
|
Output:
Change Password using Management Studio
Step 1
Login into SQL Server 2008 using Windows Authentication
Step 2
Open Object Explorer and expand Security folder. Now right-click on sa account and go to Properties.
Step 3
Change SA password and confirm password. Click OK.
Now password is changed.