Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.