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 know this is really basic, but I can't find the answer in Google or SF, so I thought I'd better just ask.

If I run SQL Server 2008 R2 Management Studio on my PC, can I manage a SQL Server 2000 database server?

I know I can do it from SQL Server 2008 (non-R2) Management Studio, though I need a legacy component to manage Data Transformation Services. I can cope fine without that component - all my DTS has been migrated to SSIS on a SQL 2005 / 2008 Servers, but I still have a legacy 2000 server and I'd like to be able to admin everything from one console.

share|improve this question
Are you sure you are running SQL Server 2010 Management Studio? It seems not exists on Microsoft site. Or do you have this: – lg. Jul 28 '10 at 10:00
Apologies, I meant 2008 R2, not 2010. Have edited. – Richard Gadsden Jul 28 '10 at 16:08
up vote 0 down vote accepted

Yes it can connect to a SQL Server 2000 instance. You do lose some functionality like the activity monitor so depending on your daily needs in terms of database monitoring you may need to have multiple version of the management studio installed.

share|improve this answer

I'm pretty sure that it can connect to a SQL 2000 server.

share|improve this answer

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.