No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

SQL server 2008 R2 evaluation period has expired

Publication Date:  2016-01-16 Views:  99 Downloads:  0
Issue Description

In S project ,BMU can not connect to the database .

cid:image026.png@01D14EB6.2129FFB0

Alarm Information

After checking the database, found a alarm "SQL server 2008 R2 evaluation period has expired"

cid:image013.png@01D14EE0.164B9CF0


Handling Process
Stop all the service of SQL ,then change the operating system time to the date when the evaluation version hasn't expired .Then start the SQL server service . Issue was avoid .
Root Cause
It is not a normal to install a evaluation version instead of commercial version , the evaluation version we can only use for demo .
Solution


The correct way to upgrade evaluation version to commercial version as below :

  1. Insert the SQL Server installation media. From the root folder, double-click setup.exe or launch the SQL Server Installation Center from Configuration Tools. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.
  2.  
    1. To upgrade an existing instance of SQL Server 2008 to a different edition, from the SQL Server Installation Center click Maintenance, and then select Edition Upgrade.If Setup support files are required, SQL Server Setup installs them. If you are instructed to restart your computer, restart before you continue.


    1. The System Configuration Checker runs a discovery operation on your computer. To continue, click OK.


    1. On the Product Key page, select a radio button to indicate whether you are upgrading to a free edition of SQL Server, or whether you have a PID key for a production version of the product. For more information, see Editions and Components of SQL Server 2008 and Supported Version and Edition Upgrades.


    1. On the License Terms page, read the license agreement, and then select the check box to accept the licensing terms and conditions. To continue, click Next. To end Setup, click Cancel.


    1. On the Select Instance page, specify the instance of SQL Server to upgrade.


    1. The Edition Upgrade Rules page validates your computer configuration before the edition upgrade operation begins.


    1. The Ready to Upgrade Edition page shows a tree view of installation options that were specified during Setup. To continue, click Upgrade.


    1. During the edition upgrade process, the services need to be restarted to pick up the new setting. After edition upgrade, the Complete page provides a link to the summary log file for the edition upgrade. To close the wizard, click Close.


    1. The Complete page provides a link to the summary log file for the installation and other important notes.


    1. If you are instructed to restart the computer, do so now. It is important to read the message from the Installation Wizard when you are done with Setup. For information about Setup log files, see View and Read SQL Server Setup Log Files.


    1. If you upgraded from SQL Server Express, you must perform additional steps before you can use your upgraded instance of SQL Server:



    • Enable the SQL Server Agent service in Windows SCM.

    • Provision the SQL Server Agent service account by using SQL Server Configuration Manager.

    In addition to the steps above, you may need to do the following if you upgraded from SQL Server Express:

    • Users that were provisioned in SQL Server Express remain provisioned after the upgrade. Specifically, the BUILTIN\Users group remains provisioned. Disable, remove, or reprovision these accounts as needed. For more information, see Configure Windows Service Accounts and Permissions.

    • Sizes and recovery mode for the tempdb and model system databases remain unchanged after the upgrade. Reconfigure these settings as needed. For more information, see Back Up and Restore of System Databases (SQL Server).

    • Template databases remain on the computer after the upgrade.

    END