Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just tried installing the SQL Server 2000 client tools on a new Win2008 R2 server (being used for development and testing) using the "standard" install CD. It can't proceed because SQL 2000 isn't supported.

I don't want to install the server, just the client tools (Enterprise Manager and Query Analyser). Is there any way to do this?

share|improve this question
up vote 3 down vote accepted

You can connect to and manage SQL 2000 using SQL Management Studio which ships with SQL 2005 and 2008. You can also download SQL Management Studio Express free from Microsoft.

share|improve this answer
I've installed SQL2008 and it looks like I can access/explore the DTS jobs setup on the SQL2000 server too (although I need to install some backward compatibility feature from SQL2005 first but my question here has been answered). Thanks – Dan Jan 4 '10 at 15:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.