You may encounter connectivity issues when you connect an application to SQL Server 2008 CTP

This article has been archived. It is offered "as is" and will no longer be updated.
Beta Information
This article discusses a beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this beta product. For information about how to obtain support for a beta release, see the documentation that is included with the beta product files, or check the Web location where you downloaded the release.
INTRODUCTION
When you connect an application to Microsoft SQL Server 2008 Community Technology Preview (CTP), you may encounter connectivity issues. This problem may occur if one of the following conditions is true:
  • The application is based on the Microsoft .NET Framework 2.0. And, the application is run on a system that has the .NET Framework 2.0 Service Pack 1 (SP1) installed. (This includes the .NET Framework 2.0 SP1 CTP).
  • Microsoft Visual Studio 2005 or Microsoft Visual Studio 2008 is used to create a connection to a SQL Server 2008 database server. The connection is created to use the Visual Studio data tools for rapid-application development (RAD).
Be aware of the connectivity issues before you perform the following operations:
  • Upgrade the end-user operating system to the Windows Vista operating system with SP1 Beta. Or, upgrade the end-user operating system to Windows Server 2008 Release Candidate 0 (RC 0).
  • Upgrade the .NET Framework 2.0 that is installed on end-user systems to the .NET Framework 2.0 SP1.
  • Upgrade the back-end database to SQL Server 2008 CTP.
More information

Design-time connectivity between Visual Studio and SQL Server 2008 CTP

If you use Visual Studio 2005 or Visual Studio 2008 to develop an application, you may be unable to connect to any instances of SQL Server 2008 CTP. This problem is most significant for Visual Basic developers and for Visual C# developers, because this problem blocks the use of any rapid application development (RAD) features.

This connectivity issue is caused by a compatibility problem between the SQL Server Management Objects (SMO) layer that is included in Visual Studio and the SMO support that is provided in SQL Server 2008. Microsoft will release updates for Visual Studio 2005 and for Visual Studio 2008 that will fix this issue.

Runtime connectivity to SQL Server 2008 if the application uses the System.Data.SqlClient namespace

In the operating systems that have the .NET Framework 2.0 SP1 installed, applications that use the System.Data.SqlClient namespace to provide data access cannot connect to certain versions of SQL Server 2008 CTP. This problem may occur depending on the .NET Framework version that is installed on the client, and depending on the SQL Server 2008 CTP version that is installed on the server. If you use an incompatible combination of SQL Server 2008 CTP and the .NET Framework 2.0 SP1, the application and the back-end database cannot be connected.

The System.Data.dll file contains the System.Data.SqlClient namespace and is included in the .NET Framework 2.0 SP1. The .NET Framework 2.0 SP1 is included in the following products:
  • Visual Studio 2008
  • Windows Vista with SP1 Beta
  • Windows Server 2008
This problem will be fixed in the RTM version of SQL Server 2008.

The following table identifies whether a connection can be established between managed data access applications that use the System.Data.SqlClient namespace and particular versions of SQL Server 2008.
Operating systemSQL Server 2008 June CTPSQL Server 2008 July CTPSQL Server 2008 November CTPNotes
Any operating system that hasVisual Studio 2008 RTMorthe .NET Framework 2.0 SP1 RTM redistributablepackageNoNoYesNot applicable
Any operating system that hasVisual Studio 2008 Beta 2orthe .NET Framework 2.0 SP1 Beta 2 redistributable package (System.Data.SqlClient, version 2.0. 50727.1378)NoYesNoNot applicable
Windows Vista with SP1 Beta(System.Data.SqlClient, version 2.0.50727.1427)NoNoYesNot applicable
Windows Server 2008 RC0(System.Data.SqlClient, version 2.0.50727.1427)NoNoYesNot applicable
Any operating system that hasVisual Studio 2005 RTMorthe .NET Framework 2.0 RTM(System.Data.SqlClient, version 2.0.50727.42)YesYesYesThese connections from the .NET Framework 2.0 RTM use SQL Server 2005 data type compatibility.
Any operating system that hasVisual Studio 2005 SP1(System.Data.SqlClient, version 2.0.50727.832)YesYesYesThese connections from the Visual Studio 2005 SP1 use SQL Server 2005 data type compatibility.

Feature availability

The following table identifies the SQL Server 2008 features that are supported in different combinations of the .NET Framework 2.0 SP1 and SQL Server 2008.
CombinationSQL Server 2008 July CTPSQL Server 2008 November CTPSQL Server 2008 future CTP and RTMNotes
Any operating system that hasVisual Studio 2008orthe .NET Framework 2.0 SP1 Beta 2 redistributablepackage (System.Data.dll,version 2.0.50727.1378)Table-valued parameters, and new date and time data typesNo connectivityNo connectivityThe SQL Server 2008 July CTP features are not available in managed stored procedures.
Any operating system that hasVisual Studio 2008orthe .NET Framework 2.0 SP1 redistributablepackage (System.Data.dll,version 2.0.50727.14xx)No connectivityTable-valued parameters, new date and time data types, large user-defined (UDT), and filestreamTable-valued parameters, new date and time data types, large UDT, and filestreamThe SQL Server 2008 November CTP features are not available in managed stored procedures.
Windows Vista with SP1 Beta(System.Data.SqlClient, version 2.0.50727.1427)No connectivityTable-valued parameters, new date and time data types, large UDT 1, and filestreamTable-valued parameters, new date and time data types, large UDT, and filestreamThe SQL Server 2008 November CTP features are not available in managed stored procedures.
Windows Server 2008 RC0(System.Data.SqlClient, version 2.0.50727.1427)No connectivityTable-valued parameters, new date and time data types, large UDT, and filestreamTable-valued parameters, new date and time data types, large UDT, and filestreamThe SQL Server 2008 November CTP features are not available in managed stored procedures.
Note Windows Vista RTM includes the .NET Framework 2.0 RTM. However, Windows Vista RTM does not contain support for any new SQL Server 2008 features that are introduced in the .NET Framework 2.0 SP1.
Properties

Article ID: 945627 - Last Review: 01/16/2015 09:59:21 - Revision: 2.0

  • Windows Vista Ultimate
  • Windows Vista Enterprise
  • Windows Vista Business
  • Windows Vista Business 64-bit Edition
  • Windows Vista Enterprise 64-bit Edition
  • Windows Server 2008 Standard
  • Windows Server 2008 Enterprise
  • Windows Server 2008 Datacenter
  • Microsoft Visual Studio 2008 Professional Edition
  • Microsoft Visual Studio 2008 Standard Edition
  • Microsoft Visual Studio Team System 2008 Database Edition
  • Microsoft Visual Studio Team System 2008 Architecture Edition
  • Microsoft Visual Studio Team System 2008 Development Edition
  • Microsoft Visual Studio Team System 2008 Test Edition
  • Microsoft Visual Studio Team System 2008 Team Suite
  • Microsoft Visual Studio 2005 Professional Edition
  • Microsoft Visual Studio 2005 Standard Edition
  • Microsoft Visual Studio 2005 Team Edition for Database Professionals
  • Microsoft Visual Studio 2005 Team Edition for Software Architects
  • Microsoft Visual Studio 2005 Team Edition for Software Developers
  • Microsoft Visual Studio 2005 Team Edition for Software Testers
  • Microsoft Visual Studio 2005 Team Suite
  • Microsoft .NET Framework 2.0
  • kbnosurvey kbarchive kbhowto kbexpertiseadvanced kbinfo KB945627
Feedback