Sunday, April 14, 2013

A downgrade path is not supported. Could not open new database

I've been troubled by this issue for a long time whenever I open a project on Visual Studio 2010. After spending quite a long time with it I figured the exact issue behind it. Just pointing it out for those who are confused by that. 

This is the error I get :
The database 'PATH/MyDatabase.mdf' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'PATH/MyDatabase.mdf'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file PATH/MyDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Screenshot:




Reason:

The reason I received such message is because it is conflicting with multiple SQLExpress instances. I run SqlExpress 2005/2008 services in this machine and by default it is starting/choosing with SqlExpress 2005 instance where as I am using SqlServer 2008 version for this particular project. 


Solution:

Just choose the exact instance which is supporting the database


How to resolve:

1. Right click on the database file and choose Modify Connection
2. Click on Advanced button
3. It will open up Advanced Properties from which just check Data Source. From the drop down you may see all running Server instances. Choose the exact one supporting your database.
4. Click OK and check connection by clicking on Test Connection button. If the connection is proper it will show a succeeded message.

Hope it helps



No comments:

Post a Comment