Existence of SQL Server 2005 and 2008 instance on the same server

• viduvs

  Ten Centuries

  Points: 1026

  More actions

  June 23, 2011 at 6:30 am

  #253251

  I have a production system where SQL Server 2005 SP3 has been installed and a named instance running on that server.

  Now, Can I install SQL Server 2008 R2 on the same server and create an another named instance?

  I want both instances running with their respective versions without impacting each other.

  If its possible, will there be any impact on running SQL Server 2005, like SQL Server 2005 Management Studio won't be accessible etc..?

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  June 23, 2011 at 9:03 am

  #1343110

  You can install both on the same server and they'll operate just fine.

  But, that's not saying that they won't impact each other. You will see contention for resources.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning