none
SQL Server 2008 R2 product key change on production server

    Question

  • Hello,

    We have a one production server which has Microsoft SQL Server 2008 R2 (RTM) -  Standard Edition (64-bit). This SQL server 2008 R2 is already activated with valid product key and is good. When this server was shipped from DELL it came up with SQL Server 2012 media but we support SQL Server 2008 R2 standard so we used one of our own license copy to activate this server. Now we traded this 2012 media with Microsoft and they have sent us back SQL Server 2008 R2 standard edition media with product key and now we want to use this new product key.

    How can we change this product key on production server? Will it affect the server in case of changing the product key fails? Will the instance get corrupt?

    I have one solution but I am not sure of.

    By using the configuration manager, run the installation wizard, maintenance --> edition upgrade--> and there we can enter new product key.

    But will this go smoothly? as we are not upgrading the edition of sql server. It has SQL Server 2008 R2 standard edition now and new one is also same one. Just product key will be different.

    Your help is much appreciated.

    Thank you.

    Friday, March 01, 2013 9:00 PM

Answers

All replies

  • Hello,

    You just have to perform an edition upgrade using the following article:

    http://msdn.microsoft.com/en-us/library/cc707783(v=sql.105).aspx

    You won’t lose any current configuration on that server.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, March 01, 2013 11:12 PM
    Moderator
  • Thank you Alberto for the reply.

    Can I just go ahead with the following:

    Start->Microsoft SQL Server 2008 -> Configuration Tools ->SQL Server Installation Center ->Maintenance->Edition Upgrade-> and enter new product key and complete the wizard.

    Will this work without any problem?

    Thank you,

    Friday, March 08, 2013 9:37 PM
  • Hello,

    Yes, it will work without any problem.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Friday, March 08, 2013 10:02 PM
    Moderator
  • Hi Alberto, 

    I followed below way:

    Start->Microsoft SQL Server 2008 -> Configuration Tools ->SQL Server Installation Center ->Maintenance->Edition Upgrade-> and enter new product key and complete the wizard.

    But it gives following error:

    The SQL Server product key is not valid. To proceed, re-enter the product key values from the Certificate of Authority(COA) or SQL Server pakaging.

    I am sure this key is not used anywhere.

    Please help with this.

    Thank you,

    

    

    Tuesday, March 12, 2013 1:47 AM
  • Hello,

    Please call Microsoft Licensing about this issue. You can call them at 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. You can also visit the following site for more information and support on licensing issues:

    http://www.microsoft.com/licensing/mla/default.aspx

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, March 12, 2013 3:02 AM
    Moderator