sql 2008 and R2 in 1 machine?

Question

sql 2008 and R2 in 1 machine?

smile_netz

Ten Centuries

Points: 1018
More actions
December 16, 2010 at 6:31 pm

#230888

Hi,
Is it possible to install a SQL 2008 R2 evaluation copy on a machine thas has a SQL 2008 STD edition installed on it already?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 1

They both share the same major version so you can do a side-by-side install but some of the components will be upgraded to SQL Server 2008 R2.

Check this TechNet article

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

smile_netz Ten Centuries Points: 1018 More actions · Answer 2

smile_netz

Ten Centuries

Points: 1018

December 16, 2010 at 9:34 pm

#1263876

Thanks Shawn!

vincenzo.capelli SSC Rookie Points: 38 More actions · Answer 3

I have just installed a cluster with a sql server 2008 r2 instance, now I'm trying to install a new istance with sql 2008 (not r2) and the setup fail while installing setup support tools.

Is possibile to install a sql 2008 instance after a sql 2008 r2 or there are some incompatiblity with support tools?

The errore I have is:

TITLE: Microsoft SQL Server 2008 Setup

------------------------------

The following error has occurred:

Unable to open Windows Installer file

'D:\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi'.

Windows Installer error message:

The system cannot open the device or file specified.

.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

thanks for your support.

Regards

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 4

Gail Shaw recommended that I install regular 2k8 first, then R2 second, just to be on the safe side. I don't know if there are issues, but I'd take her sage advice as gospel in a case like this.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

It's pretty much a golden rule with Microsoft products in general, install in chronological order. ie Office 2007 before office 2010 if you need both, SQL 2005 before SQL 2008. Often stuff breaks or behaves badly when done the other way around.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass