How to change the product key of SQL server 2008 R2

sql-server-2008

I am currently using SQL server 2008 R2 Standard edition in a Cluster. During the initial installation I used the product key which was automatically bonded with the setup DVD. Now I have a need to change the product key, keeping the same edition, without reinstalling SQL server.

I have tried the Maintenance->Edition Upgrade option from SQL Installer Center but no luck. Please let me know if there is any alternative way to change the product key.

Best Answer

I don't know what you mean by 'no luck' as that is the main method of changing the CD-key for SQL, but you can also try command line "Setup.exe /q /ACTION=editionupgrade /INSTANCENAME= /PID=" /IACCEPTSQLSERVERLICENSETERMS"

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

You cannot use these methods to downgrade if you are looking to go that route. If it is a current cluster, you should be able to update the key on one node and then trigger a failover to automatically update the other node(s).

Related Topic