Step 6: Upgrade SQL 2008 to SQL 2008 R2
Upgrading the SQL Server 2008 Enterprise SP2 binaries to SQL Server 2008 R2 Enterprise:
Upgrading SQL Server 2008 SP2 to SQL Server 2008 R2
Re-register the SQL server
Upgrading SQL Server 2008 SP2 to SQL Server 2008 R2
The next step is to upgrade SQL Server on APP1.
To Upgrade SQL Server 2008 SP2 to SQL Server 2008 R2
On APP1, navigate to the directory that contains the SQL Server 2008 R2 Enterprise binaries and double-click Setup.EXE. This will launch the SQL Server Installation Center.
On the SQL Server Installation Center, on the left, click Installation.
On the right, click Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008. This will launch the SQL Server 2008 R2 Setup.
On the Setup Support Rules screen, click OK. This will close the Setup Support Rules screen and will bring up the Product Key screen.
On the Product Key screen, enter your product key, and then click Next.
Important
The retail version of SQL Server 2008 R2 Enterprise from Microsoft MSDN® was used in creating this test lab guide. If you are using a volume license copy the key may already be provided.
On the License Terms screen, read the Licensing terms, select the I accept the license terms check box, and then click Next.
On the Setup Support Files screen, click Install. This will take a few moments to complete. Once this completes the Setup Support Rules screen will appear again.
Warning
You may get a window pop-up that says the One or more affected files have operations pending. You must restart your computer to complete this process. Click OK.
On the Setup Support Rules screen, click Next.
On the Select Instance screen, click Next.
On the Select Features screen, click Next.
On the Instance Configuration screen, click Next.
On the Disk Space Requirements screen, click Next.
On the Server Configuration screen, click Next.
On the Full-Text Upgrade screen, select Rebuild, and click Next.
On the Error Reporting screen, click Next.
On the Upgrade Rules screen, once it completes, click Next.
On the Ready to Upgrade screen, click Upgrade.
On the Upgrade Progress screen, wait until the installation completes.
Warning
You may get a window pop-up that says the One or more affected files have operations pending. You must restart your computer to complete this process. Click OK.
On the Complete screen, click Close. You will be prompted to restart the computer. Click OK.
Close the SQL Server Installation Center.
Restart APP1.
Re-register the SQL server
In this step, we will re-register the SQL Server. This will be done by bringing up the SQL Server Management Studio.
To re-register the SQL server
Log on to APP1.corp.contoso.com as Administrator.
Click Start, click All Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio. This will launch SQL Server Management Studio.
On the Connect to Server dialog box, under Server Type select Database Engine.
On the Connect to Server dialog box, under Server name select APP1.
On the Connect to Server dialog box, under Authentication select Windows Authentication.
Click Connect. This should be successful and the database information will be displayed on the left. The SQL Server Agent should have a green arrow.
On the left, at the top, right-click APP1 (SQL Server 10.50.1600 – CORP\Administrator) and select Register. This will bring up the New Server Registration.
Click Test. This should come back with a window that says The connection was test successfully. Click Ok.
Click Save.