The database "cannot be opened because it has version 661" when a .mdf file is attached

Question

I am trying to connect MvcMusicStore.mdf to an instance. \ SQLEXPRESS (sql server version 10.0.2531) in SQL Server 2008 R2 Management Studio. I got db from this project: http://mvcsitemap.codeplex.com/releases/view/67151

When I try to connect, I get an error message:

The database 'C:\PROJECTS\CODEPLEX\TFS10\MVCSITEMAP\BRANCHES\3.1.0\SRC\MVCSITEMAPPROVIDER\MVCMUSICSTORE\APP_DATA\MVCMUSICSTORE.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. 

Do I need to update my SQL server or something else?

Answer 1

Your instance of SQL Server Express is version 2008 and the database is from 2008 R2. To restore the database, you will have to upgrade to SQL Server Express 2008 R2. It doesn’t matter that you are using Management Studio 2008 R2 - you must also upgrade the database instance.

See SQL Server: Install Invalid Version 661