Solved

What are steps to change SA account password in sql server 2008?

Posted on 2012-03-12
2
199 Views
Last Modified: 2012-08-13
Hi there,
I need to change  the SA account password as a part of the security auditing .... what are steps do that and what's the look out for in sql server 2008?  Thank you in advance for your help
0
Comment
Question by:hpradhan08
2 Comments
 
LVL 6

Accepted Solution

by:
Peter Kiprop earned 500 total points
ID: 37713292
Hi hpradhan08,

There are two ways you can change your password. 1 is by use of code and 2 by using management studio.

To use option one use the below code;

ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'Younewpassword' MUST_CHANGE
GO

Open in new window



the above code will overwrite the current password. This will also help when you have forgotten the password.

you may as well use the below

ALTER LOGIN [sa] WITH PASSWORD = N'yourNewPassword' OLD_PASSWORD = 'yourOldPassword';
GO

Open in new window


Option two follow the link below

http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/

Hope this helps.
Pthepebble
0
 

Author Comment

by:hpradhan08
ID: 37727788
ok, thanks.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question