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 1 of 3

Published: 28 Jun 2011

Unedited - Community Contributed

Abstract
Sometimes you need to reset the password of a SQL Server database installation. This article shows you how.

by Steven Smith
Feedback

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

Article Contents:

Introduction

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

(Page 2) »

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.