How to Reset a SQL Server sa Password: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
How to Reset a SQL Server sa Password

page 3 of 3

by Steven Smith
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20845/ 37

Article Contents:

Summary

Assuming you can access the local machine with local administrator rights, it is relatively straightforward to reset the system administrator (sa) password on a MS SQL Server installation. This can be a lifesaver if you have no other way to connect to the server, but it can also be used by black hats to hack into your server. The key to avoiding this is to ensure the server itself is secure and to keep enemies from gaining access to an account with local admin privileges.

« (Page 2)

View Entire Article

User Comments

Title: Reset SQL Server Password
Name: Richard
Date: 2012-03-04 10:24:36 AM
Comment:
I also find a useful article of resetting SQL Server password, check it at: http://www.top-password.com/knowledge/change-sql-server-password.html

Title: It is also prompted for crendential
Name: Paresh Prajapati
Date: 2011-06-29 6:32:59 AM
Comment:
We are assuming sql server can not connect with windows authentication, we have only sa sysuser. If we know only one user 'sa' and we forgot password then you said as

"Now open SQL Server Management Studio and click New Query (or use the query window that opened on startup if you configured it to do so). Type in the following:"

This is also prompted for crendential.