Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are needing to perform a repair installation of our MS SQL Server 2008 R2 installation and cannot locate our original product key. Is there some way in which we can recover our product key from the existing machine's registry before we uninstall and re-install the software?

share|improve this question
add comment

3 Answers

up vote 1 down vote accepted

Depending on how you purchased Sql Server, there may not be a separate product key:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/690741ca-2587-4e35-95b1-8caf8ff76e06

When you get SQL Server via the Volume Licensing Service Center, usually the product key is populated automatically.

share|improve this answer
add comment

Try over the top solutions product key finder. I have had to use this tool several times. Or you could look around the registry at this location: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup under ProductCode

share|improve this answer
    
Thanks for the quick reply. That key in the registry seems to be in some type of encoded format. Do you know how one can go about decoding that value into the key that we normally find on the box, etc. –  John Dec 11 '10 at 6:20
    
Ah, right, its hashed. You can use magicaljellybean key finder program or the over the top solution to un-hash the code. –  Fergus Dec 11 '10 at 6:29
1  
Unless an idiot writes a pseudo has, a hash is not reversible. Per definition. Like your passport number can not be decrunched to your real name. –  TomTom Jan 22 '11 at 21:17
    
Try this to reverse it ... mspowershell.blogspot.com/2009/02/… –  jcolebrand Nov 16 '12 at 22:56
add comment

I've successfully used Belarc Advisor free version to extract serial numbers for all the Microsoft product lines. Added bonus of having an inventory of your machine is handy to have around.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.