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 have SQL Server 2005 on my work station and on my Server, we have SQL Server 2008. When I tried to connect to SQL Server 2008 from my SQL Server 2005 edition, I am receiving the following error:

This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers.

Without installing SQL Server 2008 on my workstation, is there any way for me to connect to SQL Server 2008 from SQL Server 2005 ?

share|improve this question
up vote 4 down vote accepted

This is a known issue. Please see the following KB article for a resolution: FIX: You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008

share|improve this answer

You can install a newer version of Management Studio on your workstation without changing or replacing your SQL Server 2005 instance.

Ideally, the machine where you manage from has a version of Management Studio that is always >= the highest version of any instance that you manage.

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.