如何修复Visual Studio的错误“不支持此服务器版本..."；对于SQL Server 2012 [英] How to fix Visual Studio's error "This server version is not supported..." for SQL Server 2012

问题描述

我最近在Windows Server 2008 R2计算机上安装了Visual Studio 2010和SQL Server 2012-(包括所有更新/Service Pack).

I recently installed Visual Studio 2010 and SQL Server 2012 on a Windows Server 2008 R2 machine - (including all updates/Service Packs).

在Visual Studio中尝试在SQL Server数据库上工作时，VS会引发以下错误:

When attempting to work on a SQL Server database from within Visual Studio, VS throws the following error:

不支持此服务器版本.仅符合Microsoft SQL的服务器 支持Server 2008

This server version is not supported. Only servers up to Microsoft SQL Server 2008 are supported

我记得当我将SQL Server 2008实例更新为SQL Server 2008 R2 时(在另一台计算机上)遇到相同的错误.当时的解决方法是安装(或重新安装)Visual Studio 2010 SP1.

I recall getting this same error a while back (on a different computer) when I updated a SQL Server 2008 instance to SQL Server 2008 R2. The fix, back then, was to install (or reinstall) Visual Studio 2010 SP1.

现在，我再次(在新计算机上)收到此错误，我认为重新安装VS SP1就像在前一段时间一样是合理的.但是，这样做并不能解决问题.

Now that I'm receiving this error again (on a new computer), I thought it reasonable to reinstall VS SP1 just like I did a while back. However, doing so did not fix the problem.

似乎Visual Studio可能需要其他更新才能支持SQL Server 2012实例.

It appears as though Visual Studio may need another update to support SQL Server 2012 instances.

为清楚起见，以下是我产生错误的步骤:(使用VS 2010sp1和SQL2012)

For clarity, here are the steps that I did to produce the error: (using VS 2010sp1 and SQL2012)

1. 使用VS创建Windows Forms应用程序
2. 右键单击该项目，然后选择添加>新建项
3. 选择基于服务的数据库"
4. 取消数据源配置向导"
5. 数据库将出现在解决方案资源管理器中的项目下.双击新数据库
6. 该数据库将被添加到Server Explorer的数据连接列表中
7. 在服务器资源管理器中，打开数据库，右键单击表"目录，然后选择添加新表"
8. 引发错误不支持此服务器版本...."

截屏，以了解其价值.

Screenshots for whatever its worth..

我的问题是，对此是否有解决方法?如果是这样，那是什么?

My question is, is there a fix for this? If so, what is it?

推荐答案

也许获得 SQL Server数据工具，哪些可与SQL Server 2012一起使用?我相信 Developer Training Kit 中有一些不错的教程和其他资料.我认为还没有任何技巧可以使Visual Studio/Data Dude的旧版本与SQL Server 2012兼容.

Maybe get SQL Server Data Tools, which work with SQL Server 2012? I believe there are some good tutorials and other materials in the Developer Training Kit. I don't think there are any tricks yet to make an older version of Visual Studio / Data Dude compatible with SQL Server 2012.

这篇关于如何修复Visual Studio的错误“不支持此服务器版本..."；对于SQL Server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！