How to upgrade from evaluation or trial edition to full or retail edition of SQL Server

When the evaluation period for your SQL Server 2008 Evaluation edition expires, you will notice the following symptoms:

SQL Server service fails to start.

The following message is logged in the Windows Application log:
SQL Server evaluation period has expired

To upgrade the Evaluation Edition to a retail edition you can use the procedure documented in the following topic in Books Online:

How to: Upgrade to a Different Edition of SQL Server 2008 (Setup)

 If the procedure documented in the above topic fails on Engine_SqlEngineHealthCheck rule, then you can use the command line installation option to skip this specific rule to allow the upgrade process to complete successfully.

To skip checking this rule, open a command prompt, change to the hard disk drive and to the folder that contains SQL Server Setup (Setup.exe).

Then, type the following command:

setup.exe /q /ACTION=editionupgrade /InstanceName=MSSQLSERVER /PID=<appropriatePid> /SkipRules= Engine_SqlEngineHealthCheck

Note: The above command line runs SQL Server setup in silent mode. For a complete list of options for running the setup from the command line, please refer to the following topic in SQL Server Books Online

For more information on the upgrade scenarios supported in SQL Server please refer to the following topic in SQL Server 2008 Books Online:

Reference: http://support.microsoft.com/kb/2020443

This entry was posted in SQL Tricks and Tips. Bookmark the permalink.

Leave a comment