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

How to show the sa Asterisk Password in sql 2005

If I log in -in sql 2005 as windows authentication , How to show the sa Asterisk Password in sql 2005
0
Ihab
Asked:
Ihab
1 Solution
 
Paul JacksonCommented:
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
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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