将VS 2010 Ultimate连接到Sql server 2012

本文介绍了将VS 2010 Ultimate连接到Sql server 2012的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我无法使用visual studio 2010终极版连接sql server 2012数据库。我在安装sql server 2012时安装了VS 2010 Service Pack 1.我收到以下错误： 数据库C：/ USERS / SACHIN / DOCUMENTS无法打开/First_Database.mdf，因为它是版本706.此服务器支持655及更早版本。不支持降级路径。无法打开新数据库C：/USERS/SACHIN/DOCUMENTS/First_Database.mdf.CREATE DATABASE is尝试为文件C附加自动命名的数据库：/USERS/SACHIN/DOCUMENTS/First_Database.mdf失败。存在同名的数据库或指定的文件无法打开，或者它位于UNC共享上。 您能告诉我出错的原因以及解决方法吗？

解决方案

这是因为您的数据库来自SQL Server 2012.解决此问题的唯一方法是从SQL Server 2012生成脚本然后在SQL Server 2008 R2中运行它。

- Amit

Hi, I am not able to connect sql server 2012 database with visual studio 2010 ultimate version. I have installed VS 2010 service pack 1 while installing sql server 2012. I am getting below error: "The database C:/USERS/SACHIN/DOCUMENTS/First_Database.mdf can not be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database C:/USERS/SACHIN/DOCUMENTS/First_Database.mdf.CREATE DATABASE is aborted. An attempt to attach an auto-named database for file C:/USERS/SACHIN/DOCUMENTS/First_Database.mdf failed. A database with the same name exists or specified file can not be opened, or it is located on UNC share." Can you please let me know the reason for the error and how to resolve it?

解决方案

This is because your database is from SQL Server 2012. The only way to resolve this as I found is to Generate Script from SQL Server 2012 then run it in SQL Server 2008 R2.

--Amit