Microsoft Download Center Archive

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

  • Published:
  • Version: 8.0
  • Category: Update
  • Language: English

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

  • 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.
Knowledge Base Articles:

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

FileSize
VS80sp1-KB954961-X86-INTL.exe
SHA1: 1c8c4e678b22dbb57a2800c18b5ac084fdaca50f
11.95 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

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


Installation Instructions

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

Related Resources