Connecting SQL Server 2008 R2 to SQL Server 2000 Initially, my desktop has been installed with SQL Server 2000 Standard Edition SQL Client. Recently, I installed SQL Server 2008 R2 client and server instance. I'm using SQL Server 2008 Management Studio to replace the old SQL Server 2000 Query Analyzer and Enterprise Manager. 

Yesterday I try to install SQL Server 2000 instance server but I cannot connect because when I register the server instant on Entrprise Manager I get a message that I should use the SQL Server Management Studio or SQL Server Management Objects (SMO). Where is my SQL Server 2000 instance?
Running SQL Server Management Studio on SQL Server 2000 is not really as supported option. Your best bet is to either upgrade the 2000 instance or to use SQLCMD (which should still work) to manage the instance from the command line.

You might be able to connect to a SQL Server 2000 from management studio 2005 (if you can find the install media).