Side by Side installation of SQL Server 2008 and SQL Server 2008 R2

Recently I had to install SQL SERVER 2008 R2 BIDS on top of a machine which already had SQL SERVER 2008 BIDS. Since SQL SERVER supports side by side installation of same/different versions (in fact we have BIDS 2005 & 2008 installed in a machine), I thought this should not have any issue. However when I started installing the R2 BIDS, the rule check generated a warning

Rule “SQL Server 2008 and SQL Server 2008 R2 Shared Component Upgrade Rule” generated a warning.

There are one or more shared components of SQL Server 2008 installed on the machine. Be aware that installing SQL Server 2008 R2 shared components will automatically upgrade the existing shared components.

On clicking the “View Detailed Report” hyperlink, at the top, it opened a htm page which details out the rule check and its result. At the end of the table, the rule “SharedComponentsUpgradeRule” raised a warning saying that all shared components will be upgraded to the higher version.

My colleague shared this link which explained what can/cannot be installed side by side. In short, SQL SERVER has some shared components not just with same versions but even across different versions. The above link lets us what are these shared components and what happens when side by side install happens. People planning for side by side installation should certainly review this link.


About Suresh Kumar D

Hardcore SQL Developer and aspiring Database Architect.
This entry was posted in SQL SERVER. Bookmark the permalink.

Leave a Reply

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

You are commenting using your 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