June 21, 2007 at 6:00 pm
Can one install a sql2000 instance on a box that has sql 2005 installed? In other words, does the instance idea suport differnet verisons of sql server or should they all be the same sql version?
TIA,
Barkingdog
June 21, 2007 at 6:55 pm
The answer is yes. If you have already a sql 2005 instance installed then you can install a named instance of sql 2000 on the same machine. The idea is to have none or one default instance of either sql 2005 or 2000 and as many named instances as your os or hardware allow.
Other thing you can do is to install your sql 2000 dbs under the 2005 installation, keeping the compatibility mode 80.
Hope this helps.
June 21, 2007 at 10:54 pm
Mulitple versions of SQL Server 2000 and 2005 are supported in a single server.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply