SQL Server 2000 and 2005 same machine?

Ok, I've seen this debated all over the place, and I am looking for an answer from someone who has actually done it. Can the two co-exist? Are there any concerns? I've heard/read that the 2000 should have SP3a applied, but nothing else about issues. Any thoughts?

I have another machine on which I can install it, but I wanted to install the SQLServer express edition with my VS on a machine that hosts my 2000 server which houses some utility stuff (website, CodeVault, etc).

Any help/suggestions would be appreciated. If I don't hear anything, I am going to go ahead and try it, once I back everything up of course. :-)

This article is part of the GWB Archives. Original Author: Theo Moore

New on Geeks with Blogs