Can SQL Srv 2000 and 2005 live together?

[TheBugSlayer]

I installed both SQL Server 2000 and SQL Server 2005 through Visual Studio 2005. I don't remember in what order. But in 2000 EM all I see is MachineName/SQLEXPRESS. When I try to browse it it says to manage its properties through SQL Server 2005.

 

[mrdenny]

Looks like you upgrade your SQL 2000 to SQL 2005.

You'll need to run through the SQL 2000 installer again and install as a different named instance (or the default instance).

And yes they can live side by side happly.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com