none
How to install SQL-Server 2008 product key after evaluation time is over

    Question

  • Hi all,

     

    in my SQL-Server 2008  installation (from de_sql_server_2008_r2_express_with_advanced_services_edition_november_ctp_x64_455228)the server is not running anymore. Apparently the evaluation time (180 days) is over and we seem not to have put in the product key. At least this is the error message I am getting.

    Unfortunately, I can not find the actual tool or application to put in the product key.

     

    Could anybody please help and let me know what I have to do to put the key in.

    Thank you very much in advance !

    Monday, September 27, 2010 6:51 PM

Answers

  • If its non-CTP version then you can just put the media and run the setup. Choose "Edition Upgrade" to go from EVAL to purchased edition.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, September 27, 2010 7:12 PM
    Moderator
  • Hello,

    If you installed sql_server_2008_r2_express_with_advanced_services_edition_november_ctp_x64_455228 that means you installed a CTP version of SQL Server and you cannot do an edition upgrade.

    You will have to install the licensed edition of SQL Server as a second instance on the same server and perform a side-by-side migration, or uninstall the current instance and install a new one with media of the media of the licensed edition of SQL Server.

    Upgrading from a CTP version is not supported.

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, September 27, 2010 7:46 PM
    Moderator
  • Hi Papju,

    Based on your description, since the current SQL Server could not started, so we could not use the original backup and restore function to recovery. However, regarding to your concern “It would be good, if I could save all the settings of the current SQL-Server version (the one that is expired) and import it into the new version, so that the Sharepoint-Server would work again”, here is a workaround for you to resolve this issue:

     

    1.       Copy the basic database file of current SQL Server instance. These database file located at %Program Files%\Microsoft SQL Server\instance_name\MSSQL\DATA by default.

    2.       Uninstall the current instance through Add\Remove Program.

    3.       Install a new instance of SQL Server, and ensure this instance has the same name of pre-version.

    4.       Stop the new installed SQL Server.

    5.       Copy the database file we have copied to the install path %Program Files%\Microsoft SQL Server\instance_name\MSSQL\DATA again.

    After these steps, we could recover all the setting of pre-installed SQL Server to the new instance.

    Please feel free to ask if you have any questions.

    Thanks,
    Weilin Qiao

    Friday, October 01, 2010 2:33 AM
    Moderator

All replies

  • Can you check error log and paste top few lines here?


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, September 27, 2010 7:11 PM
    Moderator
  • If its non-CTP version then you can just put the media and run the setup. Choose "Edition Upgrade" to go from EVAL to purchased edition.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, September 27, 2010 7:12 PM
    Moderator
  • Hello,

    If you installed sql_server_2008_r2_express_with_advanced_services_edition_november_ctp_x64_455228 that means you installed a CTP version of SQL Server and you cannot do an edition upgrade.

    You will have to install the licensed edition of SQL Server as a second instance on the same server and perform a side-by-side migration, or uninstall the current instance and install a new one with media of the media of the licensed edition of SQL Server.

    Upgrading from a CTP version is not supported.

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, September 27, 2010 7:46 PM
    Moderator
  • Hello Alberto and Balmukund,

     

    thank you very much, that was very helpful as a first step to understand my problem !!.

    Unfortunately, the above mentioned SQL-Server was installed by a co-worker who has left my workgroup. I am now stuck with this situation not being an informatics / SQL-Server specialist. I have a Sharepoint-Server installation on a second server (installed as well by the one who left ...).

    This Sharepoint-Server is using the SQL-Server and is of course not working anymore as well without the SQL-Server running. From your helpful information I understand, that I will need to install a new licensed SQL-Server version.

    It would be good, if I could save all the settings of the current SQL-Server version (the one that is expired) and import it into the new version, so that the Sharepoint-Server would work again. Is there anything special that I have to take into consideration ?

     

    Is it enough to make a backup copy of all databases, deinstall the old version, install the new one and import all databases?

    Are there any other files I need to backup ?

    For importing, can I use the restore database function or is there a special import function ?

    Fortunately, the server is running as a VM and in case I am making a mistake, we have a snapshot that could be re-installed. Unfortunately, nobody from the related Department (from my University) is using MS SQL-Server - so they can not really help, as they don´t know what to do in this case ... (linux guys ...).

    thank you so much for your help

    kind regards

     

    Wednesday, September 29, 2010 4:29 PM
  • Hello,

    Please install the licensed edition of SQL Server as I posted above.

    Move SharePoint databases from CTP instance to the newly created instance using the following link:

    http://technet.microsoft.com/en-us/library/cc825329.aspx


    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, September 30, 2010 2:31 AM
    Moderator
  • Hi Papju,

    Based on your description, since the current SQL Server could not started, so we could not use the original backup and restore function to recovery. However, regarding to your concern “It would be good, if I could save all the settings of the current SQL-Server version (the one that is expired) and import it into the new version, so that the Sharepoint-Server would work again”, here is a workaround for you to resolve this issue:

     

    1.       Copy the basic database file of current SQL Server instance. These database file located at %Program Files%\Microsoft SQL Server\instance_name\MSSQL\DATA by default.

    2.       Uninstall the current instance through Add\Remove Program.

    3.       Install a new instance of SQL Server, and ensure this instance has the same name of pre-version.

    4.       Stop the new installed SQL Server.

    5.       Copy the database file we have copied to the install path %Program Files%\Microsoft SQL Server\instance_name\MSSQL\DATA again.

    After these steps, we could recover all the setting of pre-installed SQL Server to the new instance.

    Please feel free to ask if you have any questions.

    Thanks,
    Weilin Qiao

    Friday, October 01, 2010 2:33 AM
    Moderator
  • You have to insert the cd and go in the setup to [Edition Upgrade] (under the Maintenance option).

    If you just run the SQL Server Installation Center which was installed (without the CD) it doesn't activate. (just tried it here a few times, thought my product key was invalid, but you have to insert the CD and run the Edition Upgrade from the SQL Server Installation Center from the CD.

    Just put in your cd and follow this: http://blogs.msdn.com/b/petersad/archive/2011/01/24/how-to-perform-an-sql-server-edition-upgrade.aspx

    Thursday, February 09, 2012 8:17 AM
  • If you are upgrading from an Evaluation Version of SQL Server 2008 R2 to a licensed version (e.g. Standard Edition) then you have two options.  Option 1 is to put the DVD in the server drive and run the setup wizard and then choose Maintenance -> Edition Upgrade.  Option 2 (for remote installations e.g. a server in a hosted data center) you can copy the installer files from "licensed" download to the server and run the Setup.exe from the licensed installer file.  These two options work great also  when you are installing a Volume License version of SQL Server on an Evaluation Copy.  Note that just copying the Volume License key into the Edition Upgrade key field will not work.

    Good Luck!

    Tartu

    Sunday, April 01, 2012 12:21 AM