Visual Studio error message while opening a SQL Database

Asked By JamesSmith 0 points N/A Posted on - 07/21/2011

I own a small business office and deal a lot with SQL servers and exchange servers. I get the following error when I try to use Microsoft Visual Studio 2005 Service Pack 1 design tools to open a database connection with Microsoft SQL Server 2008.

Microsoft Visual Studio

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

 

I have it installed on Windows Server 2003 R2 (32-Bit x86). There are no other previous installations of Microsoft Visual Studio on this machine. I tried searching in the websites and found it could be because of the previous versions DB which is not a possibility in this case.

There are no errors when I try to open the DB and do modifications, but the moment I click on OK I get the above error message.

Does Microsoft SQL Server 2008 support MS visual studio 2005?

• Status: Open
• Question Views: 1320
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Bartholomew 0 points N/A #86352

Visual Studio error message while opening a SQL Database

Update addresses this issue and enables the following Visual Studio functionality for SQL Server 2008: 

• 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 cannot be viewed or edited in this release.
• SQL CLR projects that target SQL Server 2008 can be created and deployed to the server.
• T-SQL and SQL CLR debugging are now enabled for SQL Server 2008.
• Data binding features in Client and Web Projects are enabled.

This update does not support the following features for SQL Server 2008: 

• Creating and editing table schemas in Table Designer or Database Diagrams. As a workaround you may use the table designer feature in SQL Server Management Studio 2008 to edit table schemas in SQL Server 2008.

About Bartholomew

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/26/2011
• Question Category: MS SQL Server