How to Reset a SQL Server sa Password
page 1 of 3
Published: 28 Jun 2011
Unedited - Community Contributed
Sometimes you need to reset the password of a SQL Server database installation. This article shows you how.
by Steven Smith
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20755/ 56
Article Contents:


If you need to reset the sa (system administrator) password on a MS SQL Server database because you've lost or forgotten the old password or you've change your active directory domain, you can do so provided that you can access the server with an account that has local administrator permissions.  This article describes the steps required to do so.

View Entire Article

User Comments

Title: Reset SQL Server Password   
Name: Richard
Date: 2012-03-04 10:24:36 AM
I also find a useful article of resetting SQL Server password, check it at:
Title: It is also prompted for crendential   
Name: Paresh Prajapati
Date: 2011-06-29 6:32:59 AM
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-2024  |  Page Processed at 2024-05-18 3:24:33 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search