Want to connect to SQL 2008 from Visual Studio?

Want to connect to SQL 2008 from Visual Studio? 21 Nov 2007 12:35

Trying to connect to your new SQL 2008 November CTP instance from inside Visual Studio and getting this error?

"This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported"

Well, help is on hand for (initially for Visual Studio 2005) in the form of patch which lets VS target a SQL 2008 instance (CTP 5 up). You can grab the patch from here.

It adds:

Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas still cannot be viewed or edited in this release.

SQL CLR projects that target SQL Server 2008 CTP5 can be created and deployed to the server.

T-SQL and SQL CLR debugging are now enabled for SQL Server 2008 CTP5.
Data binding features in Client and Web Projects are enabled.

There is no patch targetting Visual Studio 2008 just yet, but apparently thats in the works and will be out when CTP 6 ships (next couple of months based on the schedule).

Add a new comment:

Name:

Website:

Comment:

jb's Blog

history

blogs i read

links