How to rectify cannot be opened because it is version 852.

Hi,

I received the following message when I used VS2013 so I opened it in VS2015 but received the same message :

The database 'aspnet-MyFirstApp-20160718091622' cannot be opened because it is version 852. This server supports version 851 and earlier. A downgrade path is not supported.
Could not open new database 'aspnet-MyFirstApp-20160718091622'. CREATE DATABASE is aborted.
Cannot attach the file 'C:\Daryl-ASP.net\MyFirstApp\MyFirstApp\MyFirstApp\App_Data\aspnet-MyFirstApp-20160718091622.mdf' as database 'aspnet-MyFirstApp-20160718091622'.

I googled and found an answer in Stackoverflow but I am afraid if I followed the method to delete the bin file, what would happened if I want to use back VS2013.

For example, change to version 851 (13.0)

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

Hope someone can advise me. Tks.

First, get rid of the thought process where you are associating the version of Visual Studio and this error. Visual Studio has nothing to do with this. The error is exclusive to SQL Server.

The question is from where did you get the .mdf and .ldf files which are trying to open. These are definitely have come from some other machine.

Please refer to the following link indicating SQL Server version and internal version number.

http://sqlserverbuilds.blogspot.in/2014/01/sql-server-internal-database-versions.html

The files are created on the machine which has higher version of sql server and your computer has lower version installed. That's all to it.

The commands given on stack overflow will create another db with the version installed on your computer. Simple.

Hope it helps!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
First, get rid of the thought process where you are associating the version of Visual Studio and this error. Visual Studio has nothing to do with this. The error is exclusive to SQL Server.

The question is from where did you get the .mdf and .ldf files which are trying to open. These are definitely have come from some other machine.

Please refer to the following link indicating SQL Server version and internal version number.

http://sqlserverbuilds.blogspot.in/2014/01/sql-server-internal-database-versions.html

The files are created on the machine which has higher version of sql server and your computer has lower version installed. That's all to it.

The commands given on stack overflow will create another db with the version installed on your computer. Simple.

Hope it helps!