Change SA Password in SQL Server 2008

In this article I describe how to change the sa password in SQL Server.
  • 2800

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:

changePassword-in-sql.jpg

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.

ChangePassword-through-wizard.jpg

Step 3

Change SA password and confirm password. Click OK.

ChangePassword-through-SQL1wizard.jpg

Now password is changed.

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.