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.
According to this article (referenced originally by nopol's answer) it is possible to change the product key of a SQL Server 2008 installation by performing the following steps:
- Open SQL Server Installation Centre
- From the Maintenance screen choose Edition Upgrade
- 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
%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.
- 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.
/IACCEPTSQLSERVERLICENSETERMSparameter 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.
I would recommend that you take a look at this post: