Microsoft KB Archive/945627

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

Article ID: 945627

Article Last Modified on 12/17/2007

-

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 2008 Team Edition for Database Professionals
 * Microsoft Visual Studio 2008 Team Edition for Software Architects
 * Microsoft Visual Studio 2008 Team Edition for Software Developers
 * Microsoft Visual Studio 2008 Team Edition for Software Testers
 * Microsoft Visual Studio 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

-





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.



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.

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.

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.

Keywords: kbhowto kbexpertiseadvanced kbinfo KB945627

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.