• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

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

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
hpradhan08
Asked:
hpradhan08
1 Solution
 
Peter KipropCommented:
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
 
hpradhan08Author Commented:
ok, thanks.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now