Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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 has Visual Studio 2008 RTM or the .NET Framework 2.0 SP1 RTM redistributable packageNoNoYesNot applicable
Any operating system that has Visual Studio 2008 Beta 2 or the .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 has Visual Studio 2005 RTM or the .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 has Visual 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 has Visual Studio 2008 or the .NET Framework 2.0 SP1 Beta 2 redistributable package (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 has Visual Studio 2008 or the .NET Framework 2.0 SP1 redistributable package (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 filestream The 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 filestream The 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.

↑ Back to the top


Keywords: kbhowto, kbexpertiseadvanced, kbinfo, KB945627

↑ Back to the top

Article Info
Article ID : 945627
Revision : 3
Created on : 12/17/2007
Published on : 12/17/2007
Exists online : False
Views : 135