How to show the sa Asterisk Password in sql 2005

Ihab
Ihab used Ask the Experts™
on
If I log in -in sql 2005 as windows authentication , How to show the sa Asterisk Password in sql 2005
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Engineer
Top Expert 2011
Commented:
You can't view the sa password, if you want to reset it, open a new query window in sql server manager and run the following script :

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

Open in new window


sql-server-2005-how-to-reset-a-forgotten-password-for-the-sa-account

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial