Microsoft KB Archive/942246

= The Visual Studio 2005 CTP lets developers use Visual Studio 2005 together with SQL Server 2008 November CTP =

Article ID: 942246

Article Last Modified on 11/19/2007

-

APPLIES TO


 * Microsoft Visual Studio 2005 Professional Edition

-



SYMPTOMS
When you try to open a database connection to Microsoft SQL Server 2008 November Community Technology Preview (CTP) by using the Microsoft Visual Studio 2005 design tools, you may receive the following error message:

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



RESOLUTION
To resolve this problem, install the Visual Studio 2005 Community Technology Preview (CTP). This CTP lets developers use Visual Studio 2005 together with SQL Server 2008 November CTP.

How to obtain the Visual Studio 2005 CTP
The following file is available for download from the Microsoft Download Center:

Download the package now.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Features
After you install the Visual Studio 2005 CTP, you can use the following Visual Studio features together with SQL Server 2008 November CTP:
 * Server Explorer

Note You can use Server Explorer to connect to SQL Server 2008 November CTP. You can view and edit some database objects in Visual Studio 2005. For example, you can view and edit stored procedures and table data in Visual Studio 2005.
 * SQL Server common language runtime (CLR) projects

Note You can create and then deploy the SQL Server CLR projects to SQL Server 2008 November CTP.
 * Transact-SQL debugging
 * SQL Server CLR debugging
 * DataSet Designer
 * Data Sources
 * Data binding

Note You can use the data binding features in client projects and in Web projects.

After you install the Visual Studio 2005 CTP, you cannot use the following Visual Studio 2005 features together with SQL Server 2008 November CTP:
 * You cannot create or edit the table schemas in the Visual Studio Table Designer or in SQL Server Management Studio database diagrams.

To create and to edit the table schemas in SQL Server 2008 November CTP, use Table Designer in SQL Server Management Studio in SQL Server 2008 November CTP. To obtain SQL Server Management Studio, follow these steps:
 * Download and then install SQL Server 2008 Developer Edition November CTP.
 * During the installation, install the SQL Server Management Tools from the feature tree.
 * After the installation is complete, start SQL Server Management Studio.
 * Connect to the instance of SQL Server to which the database is attached.
 * Use Visual Studio 2005 Team Edition for Database Professionals together with SQL Server 2008 November CTP.

System Requirements

 * Windows Server 2003 Service Pack 1, Windows Vista, or Windows XP Service Pack 2
 * Visual Studio 2005 Service Pack 1
 * Access to a running instance of SQL Server 2008 November CTP.
 * The English version of Visual Studio 2005 Professional Edition or the English version of Visual Studio 2005 Team System Editions

Known Issues
 After you enable SQL Server CLR debugging in the SQL Server CLR project and on the server, you cannot step into or click the breakpoint in the project code. To work around this problem, make sure that the Assemblies node is expanded in Server Explorer. When you uninstall the Visual Studio 2005 CTP on a computer that is running Windows Vista, you may receive the following error message:

The feature you are trying to use is on a network resource that is unavailable.

To work around this problem, provide the Visual Studio installation media. Or, provide the installation network location.

Restart requirement
You must restart the computer after you apply this CTP.

File information
The English version of this CTP has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

