Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

how to reset SA password Expand / Collapse
Author
Message
Posted Wednesday, November 20, 2013 6:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 12,962, Visits: 32,498
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1516022
Posted Friday, November 29, 2013 5:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 12:34 AM
Points: 5, Visits: 14
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.
Post #1518519
Posted Friday, November 29, 2013 5:12 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
"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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1518610
Posted Tuesday, April 22, 2014 5:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 24, 2014 3:25 AM
Points: 5, 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
Post #1563792
Posted Tuesday, May 20, 2014 12:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:23 AM
Points: 45, 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
Post #1572505
Posted Monday, September 15, 2014 12:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:45 AM
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!
Post #1613544
Posted Wednesday, November 19, 2014 9:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:17 PM
Points: 4, Visits: 5
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/
Post #1636618
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse