SQL2000 & SQL 2005 same server

• SkiQueen

  SSC Rookie

  Points: 45

  More actions

  September 4, 2007 at 12:40 pm

  #118571

  Is it possible to have an instance of SQL 2000 and SQL 2005 running on the same server?

  Thanks.

• Michal Mokros

  Hall of Fame

  Points: 3259

  More actions

  September 4, 2007 at 11:42 pm

  #731391

  Yes, I have the same situation on my PC for testing purposes. I have not noticed any problem with this configuration.

• Venkatesan Prabu

  SSCommitted

  Points: 1892

  More actions

  September 5, 2007 at 1:04 am

  #731401

  Microsoft is providing a flexy option of,

   1.  Having instance with same name for 2000 and 2005

   2.  One instance of sql server 2005 which can be accessed by 2000 query analyzer

   3.  One instance of sql server 2000 which can be accessed by 2005 SSMS

  Regards,

  Venkatesan Prabu. J

  HCL technologies

  Chennai

   

  Thanks and Regards,
  Venkatesan Prabu, 😛
  My Blog:

  http://venkattechnicalblog.blogspot.com/

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  September 5, 2007 at 8:07 am

  #731516

  You can have 2000 and 2005 on same box. I believe it is recommended to install 2000 first in this situation.

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service