blocks|key|146335|text|尝试更改兼容级别，对我很有效。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|146336|验证它是什么级别|146337|USE+VJ_DATABASE;
GO
SELECT+compatibility_level
FROM+sys.databases+WHERE+name+=+'VJ_DATABASE';
GO|code-block|syntax|javascript|146338|然后使其与旧版本兼容|146339|ALTER+DATABASE+VJ_DATABASE
SET+COMPATIBILITY_LEVEL+=+110;+++
GO|146340|146341|100+=+Sql+Server+2008+|unordered-list-item|146342|110+=+Sql+Server+2012+|146343|120+=+Sql+Server+2014|146344|146345|默认情况下，Sql+Server+2014会将数据库版本兼容性更改为仅2014，使用您应该能够辨别的@@+version，即Sql+Server是哪个版本。|CODE|146346|然后运行上面的命令，将其更改为您拥有的版本。|146347|附加步骤:确保查看数据库的可访问性未重置，通过右键单击文件夹和数据库的属性来执行此操作。(确保您有权限，这样就不会被拒绝访问)|146348|entityMap^0|4|4|0|0|0|0|0|0|0|0|0|0|1E|A|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1B|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1C|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1D|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|1E|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]|$1|R|3|S|5|T|7|1G|8|@]|D|@]|E|$]]|$1|U|3|V|5|T|7|1H|8|@]|D|@]|E|$]]|$1|W|3|X|5|T|7|1I|8|@]|D|@]|E|$]]|$1|Y|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]|$1|Z|3|10|5|6|7|1K|8|@$9|1L|A|1M|B|11]]|D|@]|E|$]]|$1|12|3|13|5|6|7|1N|8|@]|D|@]|E|$]]|$1|14|3|15|5|6|7|1O|8|@]|D|@]|E|$]]|$1|16|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]]|17|$]]

Try to change the compatibility level, worked for me.

Verify what level it is 

<pre><code>USE VJ_DATABASE;
GO
SELECT compatibility_level
FROM sys.databases WHERE name = 'VJ_DATABASE';
GO
</code></pre>

Then make it compatible with the older version

<pre><code>ALTER DATABASE VJ_DATABASE
SET COMPATIBILITY_LEVEL = 110; 
GO
</code></pre>

<ul>
<li>100 = Sql Server 2008 </li>
<li>110 = Sql Server 2012 </li>
<li>120 = Sql Server 2014</li>
</ul>

By default, Sql Server 2014 will change the db versions compatibility to only 2014, using the <code>@@ version</code> you should be able to tell, which version Sql Server is.

Then run the command above to change it the version you have.

Additional step: Ensure you look at the accessibility of the DB is not reset, do this by right clicking on properties of the folder and the database. (make sure you have rights so you don't get an access denied)

blocks|key|2937531|text|对我来说，使用codedom提供的解决方案，不起作用。这里我们只能更改现有数据库的兼容版本。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2937532|但实际问题在于，由于存储格式的变化，内部数据库版本不匹配。|2937533|查看有关SQL+Server版本及其内部数据库版本和数据库兼容性级别here的更多详细信息，因此，如果您使用SQL+Server+2012+Express版本或更低版本创建数据库，这将是一件好事。或者开始使用Visual+Studio+2015预览版。|2937534|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlserverbuilds.blogspot.in/2014/01/sql-server-internal-database-versions.html|1|http://www.microsoft.com/en-in/download/details.aspx?id=29062^0|7|F|0|0|Y|4|0|1I|N|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]|$9|11|A|12|1|13]]|E|$]]|$1|J|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]|R|$5|M|N|O|E|$P|S]]]]

For me using solution provided by codedom did not worked. Here we can only changed compatibility version of exiting database.

But actual problem lies that, internal database version which do not matches due to changes in there storage format.

Check out more details about SQL Server version and their internal db version &amp; Db compatibility level <a href="http://sqlserverbuilds.blogspot.in/2014/01/sql-server-internal-database-versions.html" rel="nofollow">here</a>
So it would be good if you create your database using <a href="http://www.microsoft.com/en-in/download/details.aspx?id=29062" rel="nofollow">SQL Server 2012 Express</a> version or below. 
Or start using Visual Studio 2015 Preview.

blocks|key|2725291|text|另一种解决方案是当您从Sql+Server管理器2014“导出”数据库时，将数据库迁移到2012年。这可以在菜单Tasks->+generate+scripts+right-+on+DB中完成。只需按照以下说明进行操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2725292|https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/|offset|length|2725293|它会生成包含所有内容的脚本，然后在您的SQL+server管理器中，例如2012，按照说明中指定的方式运行脚本。我已经成功地进行了测试。|2725294|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2S|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

Another solution is to migrate the database to e.g 2012 when you "export" the DB from e.g. Sql Server manager 2014. This is done in menu Tasks-> generate scripts when right-click on DB. Just follow this instruction:

<a href="https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/" rel="nofollow noreferrer">https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/</a>

It generates an scripts with everything and then in your SQL server manager e.g. 2012 run the script as specified in the instruction. I have performed the test with success.

blocks|key|2725327|text|这个解决方案解决了我的问题：(来自：https://msdn.microsoft.com/en-us/library/ms239722.aspx)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2725328|从数据连接节点永久附加数据库文件(.mdf)的|2725329|2725330|打开数据连接的快捷菜单，然后选择添加新连接。|ordered-list-item|style|BOLD|2725331|2725332|Add+Connection对话框中的Change按钮。|2725333|选择Change+Data+Source对话框Microsoft+SQL+，然后选择OK按钮。|2725334|此时将重新显示“Add+Connection”对话框，其中Microsoft+SQL+Server+(SqlClient)显示在“Data+source”文本框中。|2725335|在“服务器名称”框中，键入或浏览到SQL+Server本地实例的路径。您可以键入以下内容：|unordered-list-item|2725336|2725337|-+"."+for+the+default+instance+on+your+computer.
-+"(LocalDB)\v11.0"+for+the+default+instance+of+SQL+Server+Express+LocalDB.
-+".\SQLEXPRESS"+for+the+default+instance+of+SQL+Server+Express.|code-block|syntax|javascript|2725338|有关SQL+Server+Express+LocalDB和SQL+Server+Express的信息，请参阅Local+Data+Overview。|2725339|2725340|选择“Use+Windows+Authentication”或“Use+SQL+Server+Attach+a+database+file，Browse”，然后打开现有的.mdf文件。|2725341|选择“确定”按钮。|2725342|2725343|新数据库将出现在服务器资源管理器中。它将保持与SQL+Server的连接，直到您显式分离它。|2725344|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ms239722.aspx|1|https://msdn.microsoft.com/en-us/library/ms233817.aspx^0|I|1I|0|0|0|0|0|M|0|0|0|3|J|6|0|2|I|N|E|16|2|0|8|E|T|W|1T|B|0|0|0|0|1I|J|1|0|0|3|Q|W|1O|0|0|9|0|0|0|1A|0^^$0|@$1|2|3|4|5|6|7|1L|8|@]|9|@$A|1M|B|1N|1|1O]]|C|$]]|$1|D|3|E|5|6|7|1P|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|1Q|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|1R|8|@$A|1S|B|1T|J|K]]|9|@]|C|$]]|$1|L|3|-4|5|6|7|1U|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|1V|8|@$A|1W|B|1X|J|K]|$A|1Y|B|1Z|J|K]]|9|@]|C|$]]|$1|O|3|P|5|6|7|20|8|@$A|21|B|22|J|K]|$A|23|B|24|J|K]|$A|25|B|26|J|K]]|9|@]|C|$]]|$1|Q|3|R|5|6|7|27|8|@$A|28|B|29|J|K]|$A|2A|B|2B|J|K]|$A|2C|B|2D|J|K]]|9|@]|C|$]]|$1|S|3|T|5|U|7|2E|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|2F|8|@]|9|@]|C|$]]|$1|W|3|X|5|Y|7|2G|8|@]|9|@]|C|$Z|10]]|$1|11|3|12|5|6|7|2H|8|@]|9|@$A|2I|B|2J|1|2K]]|C|$]]|$1|13|3|-4|5|6|7|2L|8|@]|9|@]|C|$]]|$1|14|3|15|5|I|7|2M|8|@$A|2N|B|2O|J|K]|$A|2P|B|2Q|J|K]]|9|@]|C|$]]|$1|16|3|17|5|I|7|2R|8|@$A|2S|B|2T|J|K]]|9|@]|C|$]]|$1|18|3|-4|5|6|7|2U|8|@]|9|@]|C|$]]|$1|19|3|1A|5|6|7|2V|8|@$A|2W|B|2X|J|K]]|9|@]|C|$]]|$1|1B|3|-4|5|6|7|2Y|8|@]|9|@]|C|$]]]|1C|$1D|$5|1E|1F|1G|C|$1H|1I]]|1J|$5|1E|1F|1G|C|$1H|1K]]]]

This solution solve my problem: (from: <a href="https://msdn.microsoft.com/en-us/library/ms239722.aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/ms239722.aspx</a>)

To permanently attach a database file (.mdf) from the Data Connections node

<ol>
<li>Open the shortcut menu for Data Connections and choose Add New Connection.

The Add Connection dialog box appears.</li>
<li>Choose the Change button.

The Change Data Source dialog box appears.</li>
<li>Select Microsoft SQL Server and choose the OK button.

The Add Connection dialog box reappears, with Microsoft SQL Server (SqlClient) displayed in the Data source text box.</li>
<li>In the Server Name box, type or browse to the path to the local instance of SQL Server. You can type the following:

<ul>
<li>"." for the default instance on your computer.</li>
<li>"(LocalDB)\v11.0" for the default instance of SQL Server Express LocalDB.</li>
<li>".\SQLEXPRESS" for the default instance of SQL Server Express.</li>
</ul>

For information about SQL Server Express LocalDB and SQL Server Express, see <a href="https://msdn.microsoft.com/en-us/library/ms233817.aspx" rel="nofollow noreferrer">Local Data Overview</a>.</li>
<li>Select either Use Windows Authentication or Use SQL Server Authentication.</li>
<li>Choose Attach a database file, Browse, and open an existing .mdf file.</li>
<li>Choose the OK button.

The new database appears in Server Explorer. It will remain connected to SQL Server until you explicitly detach it.</li>
</ol>

blocks|key|145198|text|我使用VS+2017。默认情况下，SQL+Server实例名称为(LocalDB)\MSSQLLocalDB。但是，将数据库的兼容级别降级到110，如@user3390927的答案所示，我可以将数据库文件附加到VS中，选择Server+Name作为"localhost\SQLExpress“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|145199|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I use VS 2017. By default SQL Server Instance name is (LocalDB)\MSSQLLocalDB.
However, downgrading the compatibility level of the database to 110 as in @user3390927's answer, I could attach the database file in VS, choosing Server Name as "localhost\SQLExpress".

I have created a sample database using SQL Server 2014 Express and added it to my Windows Form solution. When double click on it to open I get this error. 

<blockquote>
 The database cannot be opened because it is version 782. This server
 supports version 706 and earlier. A downgrade path is not supported
</blockquote>

I am using Visual Studio 2013. I really don't understand that I am using the two latest versions of Microsoft products and they are incompatible. Am I missing something? How can I open this database? 

<img src="https://i.stack.imgur.com/0pBjQ.png" alt="enter image description here">

The database cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我使用SQL Server 2014 Express创建了一个示例数据库，并将其添加到我的Windows窗体解决方案中。当双击它打开时，我得到这个错误。无法打开数据库，因为它的版本是782。此服务器支持版本706及更早版本。不支持降级路径我正在使用Visual Studio 2013。我真的不明白，我使用的是微软的两个...

问无法打开数据库，因为它的版本为782。此服务器支持版本706及更早版本。不支持降级路径
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法打开数据库，因为它的版本为782。此服务器支持版本706及更早版本。不支持降级路径EN