Microsoft KB Archive Search

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.

  1. Home
  2. FIX: "Sql Server version not supported" error when a Visual Studio LightSwitch 2011-based application publishes to a SQL Azure database server

FIX: "Sql Server version not supported" error when a Visual Studio LightSwitch 2011-based application publishes to a SQL Azure database server

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You use Microsoft Visual Studio LightSwitch 2011 to build an application that contains some user-defined tables.
  • You use a Microsoft SQL Azure database as the target database to publish the application.
  • The back-end server of the database has been upgraded to Microsoft SQL Server 2011.
In this scenario, you receive the following error message:
Sql Server version not supported.

↑ Back to the top

Cause

This issue occurs because a version-check operation fails in Visual Studio LightSwitch 2011. 

When Visual Studio LightSwitch 2011 publishes to a database, it performs a version check to determine the version of the server. However, the version check is performed incorrectly. Therefore, the version check on the upgraded back-end server fails, and the issue that is described in the "Symptoms" section occurs.

↑ Back to the top

Resolution

Update information

The update that resolves this issue is available from the following Microsoft Download Center website:
Download 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.

Prerequisites

To apply this update, you must have Visual Studio LightSwitch 2011 installed.

Restart requirement

You do not have to restart the computer after you apply this update if no instance of Visual Studio is running.

File information

The global version of this hotfix 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.
File nameFile versionFile sizeDateTimePlatform
Microsoft.data.schema.sql.dll10.0.40219.3456,127,98427-Aug-201115:33x86
Microsoft.lightswitch.design.dataaccess.internal.dll10.0.40219.345399,26427-Aug-201115:33x86

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: kbqfe, kbfix, atdownload, kbexpertiseadvanced, kbsurveynew, kbhotfixdev, kb

↑ Back to the top

Article Info
Article ID : 2603917
Revision : 1
Created on : 1/7/2017
Published on : 9/20/2011
Exists online : False
Views : 68