SA Password Recovery

Question

SA Password Recovery

Viewing 7 posts - 16 through 21 (of 21 total)

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

duocaiduoyi2009 SSC Enthusiast Points: 139 More actions · Answer 1

If you want to recover your SA password, it is extremely easy with the help ofSQL password recovery. It is quick easy-to-use and efficient.

Hope my answer can help you.

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 2

sp_help_revlogin recovery store procedure is available by microsoft

visit this link and get the required userid password with the help of this script

http://support.microsoft.com/kb/246133

My Blog
www.aureus-salah.com

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Syed Jahanzaib Bin hassan (6/28/2011)
sp_help_revlogin recovery store procedure is available by microsoft
visit this link and get the required userid password with the help of this script

sp_help_revlogin is used to copy logins along with their SID and hashed password to another server. It is not a way to get a login's password back. All that script will do is get you the hashed version of the password which is useless for the purposes of obtaining the password itself.

SQL passwords are stored with a on-way hash. They can't be unhashed to get back the original password.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ahfb SSC Enthusiast Points: 165 More actions · Answer 4

hi

if i have another admin user ,is it possible to recovery sa password ?

I dont Want Reset Password i'v just Recovery .

thanks

andrew gothard SSChampion Points: 12315 More actions · Answer 5

ahfb (11/8/2014)
hi
if i have another admin user ,is it possible to recovery sa password ?
I dont Want Reset Password i'v just Recovery .
thanks

If your DBA has left, you want to change the password

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

ahfb (11/8/2014)
if i have another admin user ,is it possible to recovery sa password ?

Let me quote the post right above yours

SQL passwords are stored with a on-way hash. They can't be unhashed to get back the original password.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736607 More actions · Answer 7

You cannot recover passwords. No modern, well designed software allows this. It is a big security hole.