Monday, February 1, 2010

Installing SQL Server 2008 on Windows Server 2008 R2

I was recently installing SharePoint v3 on a Windows Server 2008 R2 machine using SQL Server 2008 for database storage when I came up with a problem.

 

image_2_241B5438

 

Now that’s interesting, I thought, SQL Server 2008 has issues running on Windows Server 2008 R2. The latest version of SQL has problems on the latest version of Windows Server. Go figure. No major issue, I mistakenly thought, I’ll just follow what it says to do on the Compatibility Assistant and I should be right. Famous last words.

 

Turns out that even when you install SQL Server Service Pack 1 directly after installing SQL Server 2008 you can’t get access to the SQL instance on the machine. I did some Googling and came up with the following article which provided the resolution:

 

http://wadingthrough.wordpress.com/2009/09/14/problem-installing-sql-server-2008-on-windows-2008-r2/

 

So what I’ll do here is go into the resolution in a little more depth for people.

 

Before installing SQL Server 2008 RTM on Windows Server 2008 R2 you need to install SQL Server 2008 Service Pack 1 as this will install updated SQL Setup Files which “know” about Windows Server 2008 R2. So download the service pack and double click on the download to start the install.

 

image_4_241B5438

 

Follow the installation through and allow the Setup Support files to install after which the Service Pack installation will exit and you will be returned to the desktop. Now commence the SQL Server 2008 RTM install.

 

You will receive the same compatibility warning you always receive.

 

image_2_241B5438

 

Simply click on Run program to proceed. You can now install SQL Server 2008 RTM as you normally would from the menu.

 

image_6_37C83DCC

 

During the install you may again be prompted about compatibility issues but just continue through until the installation of SQL Server 2008 is complete.

 

Once the installation of SQL Server 2008 is complete you need to install the SQL Server 2008 Service Pack 1 to update all the SQL files (you only did the setup files before).

 

With SQL Server 2008 RTM and SQL Server 2008 Service Pack 1 now installed, your installation on Windows Server 2008 R2 should be good to go.