Sql local database cannot be opened

visual-studio-2015 localdb
Rotondof picture Rotondof · Apr 18, 2016 · Viewed 12.8k times · Source

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:

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.

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: 

(LocalDB)\MSSQLLocalDB

Does anyone know how to fix this?

Answer

Kevin picture Kevin · Apr 21, 2016

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)

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

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

Good luck!

Related questions

How to add LocalDB to Visual Studio 2015 Community's SQL Server Object Explorer?

Problem I don't understand how to make LocalDB show up in the SQL Server Object Explorer. On some VMs, it shows up automatically, on some other VMs, it doesn't. Still, after googling for hours, I don't get it. Current situation …

Read More
DACPAC won't deploy because 'can't connect to server'?

I'm trying to deploy a DACPAC to LocalDB 2012 but it's just not having it: Stack trace is as follows: ================================== Could not deploy package. (Microsoft.SqlServer.Dac) ------------------------------ Program Location: at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext …

Read More
How to download Visual Studio Community Edition 2015 (not 2017)

I have a Resharper 9x license and it is only compatible up to MS VS Community 2015 edition. I tried to download the 2015 version from Microsoft but their website stubbornly wants me to have 2017, only. Can someone please provide me a …

Read More