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

When i am trying to run my website (with aspx) this problem comes up:

An exception of type ‘System.Data.SqlClient.SqlException’ occurred in
System.Data.dll but was not handled in user code

Additional information: The database
‘C:USERSXXXXDESKTOPBERMANAPP_DATADATABASE.MDF’ cannot be opened
because it is version 706. This server supports version 662 and
earlier. A downgrade path is not supported.

Could not open new database
‘C:USERSXXXXDESKTOPBERMANAPP_DATADATABASE.MDF’. CREATE DATABASE
is aborted.

An attempt to attach an auto-named database for file
C:UsersXXXXDesktopBermanapp_dataDataBase.mdf failed. A database
with the same name exists, or specified file cannot be opened, or it
is located on UNC share.

What to do?

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Looks like the Database.mdf file was created with a later version of SQL Server Express (2012) than the one installed on the server (2008). Upgrade the server with the latest version of SQL Server Express.

Method 2

If you’re trying to attach to a local db use LocalDb (since vs2012, sql2012), ie:

Data Source=(LocalDB)v11.0;AttachDbFilename= (etc)

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0