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 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.