blocks|key|118296|text|我最近遇到了同样的问题，我安装了VS2015更新2，与您的环境相同。微软在此更新中安装MSSQL2016+RC0+...因此，您的计算机上有两个或更多版本的LocalDB。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|118297|此问题是由于您的计算机上安装了不同版本的SqlLocalDB造成的。您可以通过更改其中一台计算机上的SqlLocalDB版本来解决此问题。|118298|例如，更改为版本851+(13.0)|118299|create+of+has+>打开CMD，cd到Server\130\LocalDB\Binn")|118300|Command的SqlLocalDB文件夹(默认为"C:\Program+Files\+SQL+|unordered-list-item|118301|+"SqlLocalDB.exe“MSSQLLocalDB”)，LocalDB的实例将为deleted.|ordered-list-item|118302|Command+"SqlLocalDB.exe+|118303|+"MSSQLLocalDB"“，然后您将看到计算机中最新版本的LocalDB实例已创建。|118304|118305|118306|如何使用SqlLocalDB：https://msdn.microsoft.com/zh-tw/library/hh212961%2528v=sql.120%2529.aspx|offset|length|118307|祝好运!|118308|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/zh-tw/library/hh212961%2528v=sql.120%2529.aspx^0|0|0|0|0|0|0|0|0|0|0|F|1X|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1B|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|M|7|1D|8|@]|9|@]|A|$]]|$1|P|3|Q|5|M|7|1E|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1H|8|@]|9|@$V|1I|W|1J|1|1K]]|A|$]]|$1|X|3|Y|5|6|7|1L|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|10|$11|$5|12|13|14|A|$15|16]]]]

I had the same problem recently, I installed VS2015 Update 2, the same as your environment. Microsoft install MSSQL 2016 RC0 in this update... so there are two or more versions of LocalDB on your computer.

This problem is caused by having different versions of SqlLocalDB on your computers. You can solve this problem by changing the version of SqlLocalDB on one of your computers.

For example, change to version 851 (13.0)

<ol>
<li>Open CMD , cd to folder of SqlLocalDB (Default : "C:\Program Files\Microsoft SQL Server\130\LocalDB\Binn")</li>
<li>Command "SqlLocalDB.exe delete "MSSQLLocalDB"" , The instance of LocalDB will be deleted.</li>
<li>Command "SqlLocalDB.exe create "MSSQLLocalDB"" , Then you'll see the instance of newest LocalDB version in your computer has been created.</li>
</ol>

How to use SqlLocalDB : <a href="https://msdn.microsoft.com/zh-tw/library/hh212961%28v=sql.120%29.aspx">https://msdn.microsoft.com/zh-tw/library/hh212961%28v=sql.120%29.aspx</a>

Good luck!

blocks|key|115653|text|我在尝试打开LocalDB时遇到了同样的问题和错误。对我来说，修复它的方法是安装带有Service+Pack1的SQL+Server2014+LocaldB。我在我的MSDN订阅者下载中找到了安装。在安装过程中，它要求升级旧版本，我同意了。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|115654|entityMap^0|1K|1S|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

I had this same issue and error when trying to open a LocalDB. What fixed it for me was installing SQL Server 2014 LocaldB with Service Pack 1. I found the install in my MSDN subscriber downloads. During the install it asked to upgrade the old version and I said yes.

blocks|key|118412|text|凯文先生已经给出了解决这个问题的关键，这就是我使用的命令|type|unstyled|depth|inlineStyleRanges|entityRanges|data|118413|C:\Users\alawi>cd+C:\Program+Files\Microsoft+SQL+Server\130\Tools\Binn|code-block|syntax|javascript|118414|C:\Program+Files\Microsoft+SQL+Server\130\Tools\Binn>SqlLocalDB.exe删除已删除的MSSQLLocalDB+LocalDB实例"mssqllocaldb“。|118415|C:\Program+Files\Microsoft+SQL+Server\130\Tools\Binn>SqlLocalDB.exe创建使用13.0.1601.5版创建的MSSQLLocalDB+LocalDB实例"mssqllocaldb“。|118416|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

mr kevin have given the key to solve this howver this is the commands that work with me

<pre><code>C:\Users\alawi&gt;cd C:\Program Files\Microsoft SQL Server\130\Tools\Binn
</code></pre>

C:\Program Files\Microsoft SQL Server\130\Tools\Binn>SqlLocalDB.exe delete MSSQLLocalDB
LocalDB instance "mssqllocaldb" deleted.

C:\Program Files\Microsoft SQL Server\130\Tools\Binn>SqlLocalDB.exe create MSSQLLocalDB
LocalDB instance "mssqllocaldb" created with version 13.0.1601.5.

I recently installed VS2015 Update 2 on two different PC, one at home and one at work, with the same installer file. 

Now if I open a project with Sql LocalDB on my own PC, I obtain this error:

<blockquote>
 The database 'M:\PROJECTS\BLOG\APP_DATA\myBlog.MDF' cannot be opened
 because it is version 851. This server supports version 782 and
 earlier. A downgrade path is not supported.
</blockquote>

I cannot retrieve information about this 851 version (maybe Sql LocalDB 2016?).
I'm sure to have Sql LocalDB 2016 RC0 on both PCs, and I verifies the settings in both VS2015 is: 

<pre><code>(LocalDB)\MSSQLLocalDB
</code></pre>

Does anyone know how to fix this?

Sql local database cannot be opened

SQL Server

数据库

服务器

我最近在两台不同的电脑上安装了VS2015更新2，一台在家里，另一台在办公室，安装文件相同。现在，如果我在自己的PC上使用Sql LocalDB打开一个项目，则会出现以下错误：无法打开数据库'M:\PROJECTS\BLOG\APP_DATA\myBlog.MDF‘，因为它的版本为851。此服务器支持版本782及更早版...

问无法打开Sql本地数据库
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法打开Sql本地数据库EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法打开Sql本地数据库
EN