SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


how to reset SA password


how to reset SA password

Author
Message
Lowell
Lowell
SSC Guru
SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)

Group: General Forum Members
Points: 74895 Visits: 40985
i found this bat file from microsoft which is pretty much bullet proof:
it adds the current user as an administrator to the sql server that is prompted in the command line text.

this was a million times easier than getting the isntance in single user mode and all the other stuff involved in the original lik i provided.

http://archive.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=addselftosqlsysadmin&DownloadId=9198

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Flloriya
Flloriya
SSC Journeyman
SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)

Group: General Forum Members
Points: 86 Visits: 32
An SA password of MS SQL Server can be reset by using Windows Authentication. If Builtin/Administrator is present in the SQL Server, you can login with an ID which is member of Administrators group and reset SA password in SQL Server. Just follow the steps shown below:

Step 1: Log in to SQL server by using Windows Authentication.
Step 2: In Object Explorer, open Security folder > Logins folder.
Step 3: Right click on SA account and go to Properties.
Step 4: Type a new SQL SA password, and confirm it. Click OK to finish.

But if Basic Authentication is selected during SQL Server installation instead of Windows Authentication, then an SQL user cannot be able to follows the steps shown above. In such situation one should check some third-party SQL Password Recovery tools. I would recommend here SysInfoTools MS SQL Server Password Recovery here to reset a new password for SA login to unlock SQL Server. It allows users to reset password for both logins, individual as well as SA login.
Thanks.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)

Group: General Forum Members
Points: 221884 Visits: 42003
"Basic Authentication"? Do you mean "SQL Server Authentication"?

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
betty_bakke
betty_bakke
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 16
Don't worry, you can still regain your SA password in SQL Server with little bit of technical help and the manual solution which i am going to provide, so you can solve your problem without much confusion.

Here is how you can do it with much ease and I am quite sure that this will be a helpful information for you. Visit this post to know the steps: recover SA password :-)
Elliswhite
Elliswhite
SSC-Addicted
SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)

Group: General Forum Members
Points: 433 Visits: 54
Change SQL Server Password Using SQL Script
Try this :-
Open the SQL Server Management Studio.
Open a New Query.

Copy, paste, and execute the following:

GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO

where NewPassword is the password you wish to use for the sa account.

SSMS Expert
harry.thelong
harry.thelong
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 3
I am sorry, but I can only recommend you a paid solution. I know the frustration when we loose the credentials of our crucial data, and SQL server database password is indeed a crucial one.
You may recover SQL server password by trying an inexpensive tool by SysInfoTools. I just realized that one of the contributors above have also shared some information about it, that means I am on the rite track and the share must be worthy.

All the best!
rawatsonika4u
rawatsonika4u
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 24
The software helps SQL database users access their user accounts even if they have lost the original password or accidently blocked themselves. By using this software, users can set password for an individual or system administrator on SQL Server instantly. More information for Reset SA Password visit here : http://sonikarawat.wordpress.com/2014/07/01/how-to-unlock-sql-server-account/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search