The database cannot be opened because it is version 706. (ASP.net)

Question

In vsexpress 2012 using asp.net. Made a login page. in that I am trying to enter user name and pass word I am getting the following error

The database 'C:\USERS\XYZ\DOCUMENTS\VISUAL STUDIO 2012\WEBSITES\WEBSITE4\APP_DATA\ASPNETDB.MDF' cannot be opened because it is version 706. This server supports version 663 and earlier. A downgrade path is not supported. Cannot open user default database. Login failed. Login failed for user 'MyName\MyName Ali'.

Please suggest how to fix this

Answer 1

Version 706 is a database file from Sql Server 2012
Version 663 is a database file from Sql Server 2008R2 (post SP1 ?)

So it seems that you are trying to open an MDF file made with 2012 but the current instance of Sql Server is 2008R2. There is no way to work with that file in this situation.

You could:

• Upgrade the running instance of Sql Server to 2012
• Export a script of your database file (data and structure) with 2008 compatibility, reimport your script on a 2008R2 instance and then distribute the MDF made from the 2008R2 instance

Answer 2

Try to connect to server name "(localdb)\v11.0" check your web.config, it should mention the correct server instance used to create the MDF file