none
SQL Server 2008 R2 Product key - Not Available

    Question

  • Hi

    I downloaded SQL 2008 R2 from the SQL section of the MS website, we set it up in eval mode so we could get it up and running strait away. 

    Now we have purchased a licence through VLC, the license appears in our VLC user centre, but when it says there is no product key needed for this product

    But when i try to install an instance on the server I need to enter a product key

    Why do I not have product keys in my VLC centre? and I'm assuming this will mean that the other instance is going to stop when the 180 days runs out

    who do i contact to get the key for the license I have bought?

    Cheers

    Monday, July 02, 2012 6:10 AM

Answers

  • from where exactly did you download the ISO ?

    if it is MSDN subscriber or Technet site than the ISO images contains preset key but those SW are not allowed to be used in production environment.

    Please execute the following code to see which version you've installed

    SELECT @@version
    

    see the last few posting for the following thread with the same question:

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/eaf4168c-3ecd-45d1-bcab-725277cf0374


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Monday, July 02, 2012 10:11 AM
  • This is how I undertstand it:

    When you purchased the license, you need to download it again (from wherhever you download the "real", purchased, SQL Server). This downloaded install package will be "pre-pidded", the licence key will already be filled in for you. So if you install or upgrade using this media, you can either select a free edition (lust as you did with your original install media), or the one you have purchased which is based on your licence key, already filled in for you.


    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, July 02, 2012 11:13 AM
  • OK, so i asked first and then Google'd later, sorry

    the answer to above is here:

    http://blogs.msdn.com/b/wesleyb/archive/2010/05/03/can-i-upgrade-my-sql-server-2008-r2-trial-to-a-full-version.aspx

    Just need to choose maintenance, then can upgrade from there

    Cheers

    • Marked as answer by Tud Tuesday, January 22, 2013 3:05 AM
    Tuesday, January 22, 2013 3:05 AM

All replies

  • Do you get ISO file, right ? Try open it with MagicISO  third party tool, not via WINRAR.

    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, July 02, 2012 6:47 AM
    Answerer
  • Hi

    I downloaded it from the MSDN website, its not an ISO its an exacutable that extracts its self etc

    The issue isn't with installing it, that works fine, the issue is with the licence I bought through Vol Lic, it tells me that SQL 2008 doesn't need a key, where the the software seems to think otherwse

    Monday, July 02, 2012 7:25 AM
  • I have installed yesterday  SQL Server 2012 EE downloaded from MSDN and it worked just fine without PK.

    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, July 02, 2012 7:34 AM
    Answerer
  • OK, this is SQL 2008 R2, so perhaps it is different, when you install it, you can choose to enter a Key or choose eval mode, I chose eval mode,

    I have now bought a licence via Volume Licensing, but it did not come with a key

    Does anyone have any suggestions on why my Vol Lic did not come with a key? someone from MS licensing? 

    Monday, July 02, 2012 7:53 AM
  • This is the same with SS2008R2,no differences. Can email to VL to ask for clarification?

    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, July 02, 2012 8:00 AM
    Answerer
  • from where exactly did you download the ISO ?

    if it is MSDN subscriber or Technet site than the ISO images contains preset key but those SW are not allowed to be used in production environment.

    Please execute the following code to see which version you've installed

    SELECT @@version
    

    see the last few posting for the following thread with the same question:

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/eaf4168c-3ecd-45d1-bcab-725277cf0374


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Monday, July 02, 2012 10:11 AM
  • This is how I undertstand it:

    When you purchased the license, you need to download it again (from wherhever you download the "real", purchased, SQL Server). This downloaded install package will be "pre-pidded", the licence key will already be filled in for you. So if you install or upgrade using this media, you can either select a free edition (lust as you did with your original install media), or the one you have purchased which is based on your licence key, already filled in for you.


    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, July 02, 2012 11:13 AM
  • Hi, sorry to drag this up again, I have just gotten around to dealing with, the eval seemed to run for quite a while before I ran into trouble

    I have downloaded the new ISO from the Volume Licensing centre, ran the install and choose upgrade, and as you mentioned the key was automaticly put in

    but when I get to the features page, everything is greyed out, and it tells me "There are no features selected for upgrade" I assume this is because they are both the same version, just one has a code in the meda

    so I can't continue

    Any idea's on this? surely I won't have to remove everything and start from scratch? that would defeat having an eval verson at all!!

    any ideas?

    Tuesday, January 22, 2013 2:33 AM
  • OK, so i asked first and then Google'd later, sorry

    the answer to above is here:

    http://blogs.msdn.com/b/wesleyb/archive/2010/05/03/can-i-upgrade-my-sql-server-2008-r2-trial-to-a-full-version.aspx

    Just need to choose maintenance, then can upgrade from there

    Cheers

    • Marked as answer by Tud Tuesday, January 22, 2013 3:05 AM
    Tuesday, January 22, 2013 3:05 AM