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): 11387/ 48
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.

 


View Entire Article

User Comments

Title: Reset SQL Server Password   
Name: Richard
Date: 3/4/2012 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: 6/29/2011 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.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 10/24/2014 2:58:34 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search