Upgrade SQL Server 2005 to SQL Server 2008

The process of upgrading SQL Server 2005 to SQL Server 2008 requires three main steps. The recommended order for these steps is:

1.    Update Microsoft .NET Framework to 3.5 SP1

2.    Install Hotfix for Windows X64 (KB942288-V4)

3.    Upgrade SQL Server 2005 to SQL Server 2008

Step 1: Update Microsoft .NET Framework to version 3.5 SP1

Use the following procedure to update Microsoft .NET Framework to version 3.5 SP1.

Update the .NET Framework

1.    From your SQL Server 2008 installation media, run Setup.exe.

2.    You are prompted to update .NET Framework to version 3.5 SP1; click OK to continue with setup.

Note: If Microsoft .NET Framework 3.5 SP1 is already installed you will not be prompted to update; proceed to Step 2: Install Hotfix for Windows X64 (KB942288-V4).

3.    The .NET Framework Setup Wizard opens. Accept the license agreement, and then click Install.

4.    When the .NET Framework Setup Wizard finishes, click Exit.

5.    After the .NET Framework Setup Wizard closes, the installation wizard for the Hotfix for Windows X64 (KB942288-V4) opens.

Step 2: Install Hotfix for Windows X64 (KB942288-V4)

Use the following procedure to install Hotfix for Windows X64 (KB942288-V4).

Install the hotfix

1.    After the Software Update Installation Wizard for the Hotfix for Windows X64 opens, click Install to proceed.

When the wizard finishes, you will see the following prompt: One of the Prerequisites installed requires a reboot. Restart this computer and rerun the SQL Server 2008 setup in order to continue.

2.    Click OK, and then restart the computer.

3.    After the computer restarts, restart the SQL Server 2008 setup.

Step 3: Upgrade SQL Server 2005 to SQL Server 2008

Use the following procedure to upgrade SQL Server 2005 to SQL Server 2008.

Install SQL Server 2008

1.    From your SQL Server 2008 installation media, run Setup.exe.

2.    On the SQL Server Installation Center page, select the Installation page.

3.    On the Installation page, select Upgrade from SQL Server 2000 or 2005.

4.    On the Setup Support Rules page, confirm that there are no failures, warnings, or skipped rules. Click Show details to view all results. Click OK to proceed.

Important: If there are any failures, warnings, or skipped rules, resolve them before proceeding with setup.

5.    On the Product Key page, enter the product key, and then click Next.

6.    On the License Terms page, accept the license terms, and then click Next.

7.    On the Setup Support Files page, click Install.

8.    On the Setup Support Rules page, again confirm that there are no failures, warnings, or skipped rules. Click Next to proceed.

Important: If there are any failures, warnings, or skipped rules, resolve them before proceeding with setup.

9.    On the Select Instance page, select the SQL Server instance to upgrade, and then click Next.

10. On the Select Features page, review the list of features being upgraded, and then click next.

11. On the Instance Configuration page, select the database instance to upgrade, and then click next.

12. On the Disk Space Requirements page, confirm the displayed information, and then click next.

13. On the Server Configuration page, enter account and password information to allow administrative access to the selected SQL Server instances and accounts, and then click next.

14. On the Full-text upgrade page, select Import, and then click next.

15. On the Reporting Services Authentication page, enter your Reporting Services credentials and select Windows Authentication Mode, and then click Next.

Note: The Reporting Services Authentication page will only appear if Reporting Services is installed on the existing SQL Server installation.

16. On the Error and Usage Reporting page, select the desired options, and then click next.

17. On the Upgrade Rules page, confirm that there are no failures, warnings, or skipped rules, and then click next.

Important: If there are any failures, warnings, or skipped rules, resolve them before proceeding with setup.

18. On the Ready to upgrade page, review the features being upgraded, and then click Upgrade.

Note: You may see a dialog box that says: One or more affected files have operations pending. You must restart your computer to complete this process. If you see this dialog box, click OK, but do not restart your computer until the entire upgrade process is complete and setup has closed.

19. On the Upgrade Progress page, confirm that all features have been upgraded successfully, and then click next.

20. On the Complete page, review the setup information and confirm that the upgrade has completed successfully.

21. Click Close to end the SQL Server 2008 upgrade, and then restart the computer if required.