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

SQL Server Setup

previous page next page

The SQL Server Installation Wizard provides a single feature tree for upgrade of SQL Server components. You can also install SQL Server 2008 side-by-side with an earlier version, or migrate existing databases and configuration settings from an earlier SQL Server version, and apply them to an instance of SQL Server 2008.

For more information, see these topics:

Prerequisites

For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.

Before you upgrade the Database Engine, review the following topics:

Important:
For the SQL Server edition change to be activated, you must restart SQL Server services. This will result in application down time while services are offline.

Procedure

To upgrade to SQL Server 2008

Insert the SQL Server installation media. From the root folder, double-click setup.exe. To install from a network share, locate the root folder on the share, and then double-click setup.exe.

  • If the Microsoft .NET Framework version 2.0 installation dialog box appears, select the check box to accept the .NET Framework 2.0 License Agreement. Click Next. To quit SQL Server 2008 installation, click Cancel. When installation of .NET Framework 2.0 is complete, click Finish.

  • Windows Installer 4.5 is also required, and might be installed by the Installation Wizard. If you are prompted to restart your computer, restart, and then run SQL Server 2008 setup.exe again.

  • When prerequisites are installed, the Installation Wizard will launch the SQL Server Installation Center. To upgrade an existing instance of SQL Server 2008 to a different edition, click Advanced, and then select Edition Upgrade.

  • If Setup support files are required, SQL Server Setup will install them. If you are instructed to restart your computer, restart before you continue.

  • The System Configuration Checker will run a discovery operation on your computer. To continue, click OK. Setup log files have been created for your installation. For more information about log files, see How to: View SQL Server 2008 Setup Log Files.

  • 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 Version and Edition Upgrades.

  • 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.

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

  • The System Configuration Checker will run one more set of rules to validate your computer configuration before the edition upgrade operation begins.

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

  • During installation, the progress page provides status so you can monitor installation progress as Setup proceeds.

  • After installation, the Complete page provides a link to the summary log file for the installation and other important notes. To complete the SQL Server installation process, click Close.

  • 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 How to: View SQL Server 2008 Setup Log Files.

  • 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.
    • Users that were provisioned as Sysadmins will remain provisioned after the upgrade. Specifically, BUILTIN\Users will remain provisioned. Disable, remove, or reprovision these accounts, as it is required.
    • Sizes and recovery mode for TempDB and ModelDB will remain unchanged after the upgrade. Reconfigure these settings, as it is required.
    • Template databases will remain on the computer after the upgrade. Remove or reconfigure them, as it is required.

    • See Also

    previous page start next page