Sunday, May 02, 2010

Troubleshooting a SQL Server 2008 R2 CTP Windows 7

Microsoft SQL Server 2008 R2 was recently released. It is a major upgrade with many new features and a 'Cloud ready' database server. Accessing SQL Azure has become very easy and new features such as 'Mars' are added frequently. SQL Azure being a subset of SQL Server 2008 R2 is sure to expand to support most of the major features.

Installing SQL Server 2008 on more recent OS versions such as Vista, Windows 7, Windows Server 2008 will continue to draw attention.Installation of SQL Servers; modifying them; adding feauters and removing features / software has become very easy thanks to Microsoft in this endeavor. However it is not always a repeatable process. Read my article on installing an earlier version of SQL Server 2008 here

What makes it frustrating is the fact that there is no repeatability. For example, although this version of SQL Server software is supported on Windows XP Professional with SP3, I have not been able to install it successfully. I have not tried it recently as installation and repair of SQL Servers is neither what I do routinely nor for another reason.
I could install SQL Server 2008 R2 November-CTP easily on a new Windows 7 RC but not on this version in this article. Another reason for all this could be that being a CTP the guarantee that it is supported on a given OS is not rock solid.

This article is for an installation of SQL Server 2008 R2 NOV-CTP (x32) on a notebook computer after a fresh install of Windows 7 ultimate(x32). The download of the server software is from the Microsoft site which unpacks to a tree-view folder structure that has the file to start installing the software and all required files. The article describes the installation and troubleshooting of the installation and the work around.

Read the full article here:


To read it without becoming a member register as a guest.

No comments: Protection Status