SQL Server 2008 Running on Windows Server 2008 R2 Release Candidate

Perhaps lost in all of the hoopla and anticipation over Windows 7 is the fact that Microsoft has released the RC build of Windows Server 2008 R2 (which is the server version of Windows 7). This morning, I installed the RC Build (Build 7100) on an old Dell Precision 470 workstation that we are using as a test server.

The OS installation went smoothly and was done in about 20 minutes, with all of the devices recognized by Windows (with no bangs in Device Manager). Next, I installed the x64 version SQL Server 2008 Enterprise Edition on this machine. The experience here was a little different than installing SQL Server 2008 on Windows 7 Build 7100.

The SQL Server 2008 setup program notices that you need the .NET Framework 3.5 SP1, and tries to install it, but Windows Server 2008 R2 does not allow you to install  .NET Framework 3.5 SP1 directly. Instead, you have to use the Role Manager to install the Application Server role, which will install the .NET Framework 3.51.

After this, you will get three warnings telling you that you will need SP1 for SQL Server 2008 in order for SQL Server 2008 to work correctly on Windows Server 2008 R2. Despite this, the SQL Server 2008 install completes (at least for the Database Engine and SSMS) with no errors, and appears to work just fine after some light smoke testing.

Finally, I installed SP1 for SQL Server 2008, and then CU1 for SQL Server 2008 SP1. After all of this, here is what I get with SELECT @@VERSION:

Microsoft SQL Server 2008 (SP1) – 10.0.2710.0 (X64)   Apr  7 2009 20:36:04   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7100: )

This entry was posted in SQL Server 2008. Bookmark the permalink.

40 Responses to SQL Server 2008 Running on Windows Server 2008 R2 Release Candidate

  1. Joseph E. says:

    Have you stress tested SQL 2008 on Windows R2 2008?

  2. Edward says:

    It is good to see some prople sharing their experiences of SQL and W2008 R2.The current RC of SQL Server 2008 FineBuild on Codeplex can install SQL on Windows 2008 R2 and R2 Core. FineBuild automatically detects the install is on R2 Core and runs the necessary OCSETUP commands in place of the normal .Net 3.5 SP1 and Powershell installs. This makes the install process on R2 Core transparent to whoever is running the install.Everything on the Core install seems to work OK apart from SSRS connectivity, and when the cause is known a solution will be added to FineBuild.On the other hand I tried a SQL Server 2005 install on W2008 R2 Core and although the install completed I came across a number of permissions issues that prevent SQL 2005 working properly on W2008 R2 Core.

  3. Glenn says:

    I will be moving a couple of databases in our Dev environment to that server today, so it will see some workload.

  4. Trevor says:

    Has anyone be able to install a SQL 2008 Failover Cluster on Server 2008 R2 (RC). I\’m getting stuck on the Instance Configuration screen with the error:The given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered SQL instance due to the following error: \’The network address is invalid.\’

  5. Unknown says:

    http://www.batteryfast.com/asus/u6s.htm asus u6s battery http://www.batteryfast.com/asus/u6sg.htm asus u6sg battery http://www.batteryfast.com/asus/a31-s6.htm asus a31-s6 battery http://www.batteryfast.com/asus/a32-s6.htm asus a32-s6 battery http://www.batteryfast.com/asus/a33-s6.htm asus a33-s6 battery http://www.batteryfast.com/apple/m7426.htm apple m7426 battery http://www.batteryfast.com/apple/ibook-m2453.htm apple ibook m2453 battery http://www.batteryfast.com/apple/ibook-1999-model.htm apple ibook 1999 model battery http://www.batteryfast.com/apple/ibook-2000-model.htm apple ibook 2000 model battery http://www.batteryfast.com/toshiba/pa3366u-1brs.htm toshiba pa3366u-1brs battery http://www.batteryfast.com/toshiba/satellite-a30-921.htm toshiba satellite a30-921 battery http://www.batteryfast.com/toshiba/pa3285u-3bas.htm toshiba pa3285u-3bas battery http://www.batteryfast.com/toshiba/pa3284u.htm toshiba pa3284u battery http://www.batteryfast.com/toshiba/pa3284u-1bas.htm toshiba pa3284u-1bas battery http://www.batteryfast.com/toshiba/pa3284u-1brs.htm toshiba pa3284u-1brs battery http://www.batteryfast.com/toshiba/pa3285u-1bas.htm toshiba pa3285u-1bas battery http://www.batteryfast.com/toshiba/pa3285u-1brs.htm toshiba pa3285u-1brs battery http://www.batteryfast.com/toshiba/pa3285u-2bas.htm toshiba pa3285u-2bas battery http://www.batteryfast.com/toshiba/pa3285u-2brs.htm toshiba pa3285u-2brs battery http://www.batteryfast.com/toshiba/pa3285u-3bas.htm toshiba pa3285u-3bas battery

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s