Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines?

SQL Server 2008 R2 works fine (what I have now).

share|improve this question
I did try searching for answers to this but my Google-Fu is weak today... – Michael Haren Aug 21 '12 at 14:00
Yes, you can. I do it every day. – swasheck Aug 21 '12 at 14:33
Don't forget about the port in the connection if you have a side by side installation. For instance: DEV\SQL2000,63030 – user55145 Dec 16 '14 at 22:18
up vote 12 down vote accepted

Yes, I have done it. My website is on SQL server 2000 and I updated it last night in full windows 8, SSMS 2012 setup.

share|improve this answer
Just to be clear: you connected to SQL 2000 from SSMS 2012? Not upgraded? – Michael Haren Aug 21 '12 at 14:05
Yes. No upgrading anywhere (I don't have the money to do anything like that). – Nick Larsen Aug 21 '12 at 14:07
Cool. Thanks very much! – Michael Haren Aug 21 '12 at 14:07
Note: SQL Server 2012 Profiler does not work with SQL Server 2000 – Michael Haren Aug 21 '12 at 18:41

Yes, you absolutely CAN connect to a SQL Server 2000 instance using SSMS 2012 as a client. I do it every day as I still have 5 SQL Server 2000 instances in my environment that I manage. However, keep in mind that SSMS will present you with some options based on functions that are available in the version of SSMS you are using, and you may not be able to perform those functions from SSMS due to differences in commands between the versions.

And there are some things that SQL 2k simply doesn't like coming from SSMS. For example, if you use the GUI to manage permissions for a database role be prepared for SSMS to crash in some circumstances. For that reason it is always a good idea to keep a copy of SQL 2000 Enterprise Manager handy somewhere.

share|improve this answer

I was having "timeout" issue when trying to connect to SQL Server 2000 using Management Studio 2012. Finally the solution for me was to install Microsoft SQL Server 2000 Service Pack 4 -

I hope that this solution can be useful for someone having this problem.

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.