Reset SA password

Question

Reset SA password

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 1

Shaun Finnegan (7/6/2014)
Igor Micev (7/6/2014)
Once I had similar issue, and found this article useful
http://technet.microsoft.com/en-us/magazine/jj853293.aspx
Hi Igor, so the steps in the article resolved your issue? or did you have to change any for your circumstances?

I manage to create a sysadmin user in sql server and then did some stuff, like resetting the sa password and etc...

Igor Micev,My blog: www.igormicev.com

nickman SSChasing Mays Points: 635 More actions · Answer 2

Thanks all for your help.

I retrieved the A password using Igor's the following URL:

http://technet.microsoft.com/en-us/magazine/jj853293.aspx

Which was also posted above.

crazy4sql SSCoach Points: 19590 More actions · Answer 3

This linked helped me quiet couple of times. Though your issue is solved but you can keep this link somewhere saved in your favourites..

http://sqlserver-help.com/category/forgot-the-sa-password-in-sql-server-2005/

----------
Ashish

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 4

Igor Micev (7/6/2014)
Once I had similar issue, and found this article useful
http://technet.microsoft.com/en-us/magazine/jj853293.aspx

THAT would be the one, Igor. Thanks for posting the link.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

lkennedy76 SSChampion Points: 13683 More actions · Answer 5

I have had the same issue several times consulting. I use the link below and it works every time.

http://community.spiceworks.com/how_to/show/22044-recover-sa-password-on-microsoft-sql-server

MCSE SQL Server 2012\2014\2016

ShaunF SSChasing Mays Points: 612 More actions · Answer 6

lkennedy76 (7/7/2014)
I have had the same issue several times consulting. I use the link below and it works every time.
http://community.spiceworks.com/how_to/show/22044-recover-sa-password-on-microsoft-sql-server

Great information sharing, I'll certainly be bookmarking these links in case of emergency