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

Article translations Article translations
Article ID: 945627 - View products that this article applies to.
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.
Expand all | Collapse all

On This Page

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.
Collapse this tableExpand this table
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.
Collapse this tableExpand this table
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.

Properties

Article ID: 945627 - Last Review: December 17, 2007 - Revision: 1.2
APPLIES TO
  • 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 Express Edition
  • 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 Visual Studio 2005 Team System Test Edition
  • Microsoft .NET Framework 2.0
Keywords: 
kbhowto kbexpertiseadvanced kbinfo KB945627

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com