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.

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.

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 name

File version

File size

Date

Time

Platform

Microsoft.data.schema.sql.dll

10.0.40219.345

6,127,984

27-Aug-2011

15:33

x86

Microsoft.lightswitch.design.dataaccess.internal.dll

10.0.40219.345

399,264

27-Aug-2011

15:33

x86


Status

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

Need more help?

Expand your skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT INSIDERS >

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×