locked
Find SQL Product Key for upgrade to SQL 2008 R2 RRS feed

  • Question

  • User-120165138 posted

    Hi I am trying to update SQL 2008 to SQL 2008 R2 but it is asking me for my product key, which I don't know where its at. Is there a way to find it in the server, or something? 

    Thanks

    Thursday, April 15, 2010 12:27 AM

Answers

  • User-37275327 posted

    If there is no upgrade facility, you need to purchase seperately. What you have to pay for the upgrade.

    check this link

    http://technet.microsoft.com/en-us/library/bb677622(SQL.105).aspx


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, April 18, 2010 1:04 AM

All replies

  • User2090264947 posted

    There's absolutely no way to find out the product key in server. The product key is written on the Cover of CD or DVD of the SQL Server. So if your copy of sql server is not pirated then you must have a cd or dvd of it. Check the cover. You will get it.


    Friday, April 16, 2010 4:04 AM
  • User-120165138 posted

    Thanks for the reply,

    I actually found a utility that will retrieve the product key from within the registry incase you loose your disk. Obviously this would not work on hacked copy, hence it would be "hacked". 

    Friday, April 16, 2010 10:28 AM
  • User-37275327 posted

    If there is no upgrade facility, you need to purchase seperately. What you have to pay for the upgrade.

    check this link

    http://technet.microsoft.com/en-us/library/bb677622(SQL.105).aspx


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, April 18, 2010 1:04 AM
  • User573209779 posted

    Mr. Wheel,

     

    I am trying to do the same thing...find the sql r2 key.  I am wary of third party tools.  Would you please tell me what tool you used?

    Thanks,

    Randy

    Wednesday, June 1, 2011 1:49 PM
  • User1098876200 posted

    Hey Randy!

    I was trying to find the same "Product Key for MS SQL 2008 R2" however after some research I was able to find it under the following location in registry... Let me know if this helps ?

    HKEY_LOCAL_MACHINE,\SOFTWARE\Microsoft\Microsoft SQL Server\100\BIDS\Setup

    Cheers!

    Wednesday, August 17, 2011 12:40 PM
  • User601486644 posted

    You can find out SQL Server 2008 product key by executing this SQL script:

    USE master
    GO
    EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft
    SQL Server\80\Registration','CD_KEY'

    If this doesn't work, you can then use this product key finder program.

    Thursday, October 17, 2013 6:30 AM