Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Install a 2000 instance on SQL 2005 server

Author  Topic 

patbrost
Starting Member

5 Posts

Posted - 2007-07-25 : 11:34:35
Is it possible to install a 2000 instance on a 2005 server? Just install a named instance and install 2000 in a different directory?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-07-25 : 12:10:44
quote:
Originally posted by patbrost

Is it possible to install a 2000 instance on a 2005 server? Just install a named instance and install 2000 in a different directory?



it should be possible. We have servers with both SQL 2000 and SQL 2005 installed so I know it works. However, I have not installed an instance of SQL 2000 after a SQL 2K5 install - so I am not certain if the order things are installed is a factor.



-ec
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-25 : 15:38:09
It's possible, may need reinstall sql2k5 client tools.
Go to Top of Page

kriki
Starting Member

14 Posts

Posted - 2007-07-28 : 11:47:15
On my portable I have SQL2000 AND SQL2005SP2 and they work nice.
I even use the "SQL Server Management Studio" of SQL2005 to admin my SQL2000.
One thing: I installed SQL2000 first and then SQL2005 (with another name and subdir) and SP2 on it afterwards. I don't know if you can first install SQL2000 and then SQL2005.

IF Debugging = removing bugs from program THEN programming := putting bugs in program;
Go to Top of Page

PCNuttall
Starting Member

2 Posts

Posted - 2007-08-03 : 12:47:00
If you install SQL 2000 after 2005, you MUST apply all service packs to the 2000 instance.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-03 : 14:00:34
Always have to apply sql2k sp on win2k3.
Go to Top of Page
   

- Advertisement -