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 ?


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

| 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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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