SQL SERVER - 2008 - Fix Connection Error with Visual Studio 2008 – Server Version is not supported

While attending conference SQLAuthority Author Visit - Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are not compatible. When trying myself I got the same error.

SQL Server 2008 when connected to Visual Studio 2008 gives the error that "This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported".



This error can be easily resolved by just installing Service pack. Download Visual Studio Service Pack 1 and install. Once service pack installed it will connect just fine.

Reference : Pinal Dave (http://www.SQLAuthority.com)