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.

my version of sql server 2008 Enterprise edition has expired and I have a new key how to change the old key without uninstall or any modification to the installed server or instances.

share|improve this question
add comment

2 Answers

According to this article (referenced originally by nopol's answer) it is possible to change the product key of a SQL Server 2008[1] installation by performing the following steps:

  1. Open SQL Server Installation Centre
  2. From the Maintainece screen choose Edition Upgrade
  3. Enter the new new product key

It is also possible to change the product key at the command line using the command

Setup.exe /q /ACTION=editionupgrade /INSTANCENAME=<%INSTANCE_NAME% /PID=%NEW_PRODUCT_KEY> /IACCEPTSQLSERVERLICENSETERMS

Where:
%INSTANCE_NAME% is the SQL Server instance that will have its product ID changed`

%NEW_PRODUCT_KEY% represents the new product key that the will be applied to the specified SQL Server Instance.

Notes:

  1. The linked article specifically references changing the license key for SQL Server 2008 Developer Edition. This author is unable to determine whether this process allows changing of keys between other editions due to lack of required software to test with.
  2. The /IACCEPTSQLSERVERLICENSETERMS parameter indicates your acceptance of the SQL Server licensing terms. Make sure you understand the license terms that apply to your (or your organization) before using this switch.
share|improve this answer
    
Community Wiki because this answer just extracted information from the link posted in npol's answer, as per @Mark Henderson's suggestion. –  Crippledsmurf Jan 10 '13 at 14:37
add comment

I would recommend that you take a look at this post:

http://blog.mediawhole.com/2010/06/upgrade-sql-server-edition-or-change.html

share|improve this answer
1  
Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference. –  Mark Henderson Oct 8 '12 at 7:27
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.