We help IT Professionals succeed at work.

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

hpradhan08
hpradhan08 asked
on
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
Comment
Watch Question

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

Author

Commented:
ok, thanks.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.