SqlExpress mdf DB incompatibility

Question

0.00/5 (No votes)

See more:

I used the ASP.NET (.NET4) default ASPNETDB.mdf database that gets created when using membership, in one of my sites. I then copied the site to the web server. Now it has been running for a while so there is content and comments. But I now need to make changes to the code that will also require extra fields in the db, so I copied the .mdf from the server to my local machine to edit and add the fields(so I didnt lose content etc). But when I run the project after replacing the mdf i get the following error:

 "The database ".....APP_DATA\ASPNETDB.MDF" cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Cannot open user default database. Login failed. Login failed for user 'Me-PC\Me'.

This confuses me, as it is the exact mdf file that my home VS generated. The server is running the same .NET as I am too, so I dont see why it would have changed anything.

Thanks!

Posted 30-Sep-10 4:54am

Matt Cavanagh

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Answer 1 · 2010-09-30T05:03:00

Are you using the Express version of VS2010?

I had the same problem with my Express version. Of course it may also affect the full one too but as I don't have it I can't confirm this.

The cause in my case is that I had upgraded SQLServer2008 Express to SQLServer2008 Express R2.

Have you done that?

My problem was resolved when I installed MS LightSwitch but as this also installs loads of upgrades to EF 4.0, SilverLight etc. etc. etc. I cannot pin point the actual cure.

If no-one comes up with a definitive solution for you I would suggest that you raise this on the MS Support Forums.

Henry Minute · Answer 2 · 2010-09-30T05:28:00

I would not install LightSwitch, if I were you. After I did so my VS2008 Pro and VS2010 Express installations became flaky, they now fall over at the drop of a hat whereas before, they were rock solid.

After the install all my DB files were available.

Try MS Forums first. Only use LightSwitch as a last resort.

SqlExpress mdf DB incompatibility

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0