Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support

Brief Description

This update enables developers to use Microsoft Visual Studio 2005 Service Pack 1 with Microsoft SQL Server 2008.

Overview

This update resolves the following error that when you try to use Microsoft Visual Studio 2005 Service Pack 1 design tools to open a database connection to Microsoft SQL Server 2008 :

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

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

Top of page

System Requirements

Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 x64 editions; Windows Server 2003 Service Pack 1; Windows Server 2003 Service Pack 2; Windows Server 2003 x64 editions; Windows Vista; Windows XP Professional x64 Edition ; Windows XP Service Pack 2

Top of page

Instructions

Click the Download button on this page to start the download, or select a different language from the Change language drop-down list and click Change.
Do one of the following:

To start the installation immediately, click Run.
To save the download to your computer for installation at a later time, click Save.
To cancel the installation, click Cancel.

Top of page