SQL Server 2005 & 2008 R2

Question

SQL Server 2005 & 2008 R2

DBABC

SSCarpal Tunnel

Points: 4813
More actions
July 20, 2010 at 11:59 am

#225001

I have a machine that already has SQL Server 2005, can i install SQL Server 2008 R2 on the same machine? Does anyone know about any known issues?

Viewing 4 posts - 1 through 3 (of 3 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736458 More actions · Answer 1

Yes, it will be a named instance instead of a default instance. Your client tools will upgrade, and there are some services, like Integration Services, that are not instance aware and will upgrade.

DBABC SSCarpal Tunnel Points: 4813 More actions · Answer 2

Thanks Steve, but will this service upgrage cause any issue?

Steve Jones - SSC Editor SSC Guru Points: 736458 More actions · Answer 3

The issues are the ones that I have mentioned. If you depend on client tools or SSIS, or any non instance-aware service, or on the default instance, it could be an issue.

Otherwise it's a named instance, like any other named instance of SQL Server. The instances operate separately for instance aware services, database engine, SSAS, etc.