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

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

i have a Databse,Created in SQl-Server R2.

Now i made a Desktop application using C#,and want to Attach this databse into my application,
but when i try adding the database .MDF file it give error like this...

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

i understand that visual studio have Lower version of SQL database,so i install Visual studio 2012,
but again the problem is same...

so what can i do,and how i update Sql server of my Visual studio 2010,2012...

and my database size is 3 GB, so i also unable to Make Database SCript and then Excute it..

so plz provide and Like for update my default Sql server,which is internally install in visual stdio 2010,2012..

Same Prob is
http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661[^]

Posted 20-Aug-14 23:36pm

Arun kumar Gauttam

Updated 21-Aug-14 4:13am

v2

Add a Solution

2 solutions

Solution 1

these links may be useful for you

http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661[^]

http://conceptdev.blogspot.com/2009/04/mdf-cannot-be-opened-because-it-is.html[^]

Posted 20-Aug-14 23:43pm

ClimerChinna

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)

OriginalGriff · Accepted Answer · 2014-08-20T23:44:00

Solution 2

You may have installed VS 2012, but you are using a SQL 2008 instance: Visual studio does not install SQL for you.
SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661. You are trying to attach an 2008 R2 database to an 2008 instance and this is not supported.

You need to upgrade your SQL instance to at least 2008R2 to open the file (but be aware that if you subsequently attach your existing DBs to the new instance, you won't be able to open then in SQL 2008 again either).

Posted 20-Aug-14 23:44pm

OriginalGriff

Comments

Arun kumar Gauttam 21-Aug-14 10:13am

sir,plz provide any link for upgrade SQL instance...

OriginalGriff 21-Aug-14 10:25am

http://www.microsoft.com/en-gb/download/details.aspx?id=29062

Arun kumar Gauttam 22-Aug-14 0:34am

thanks sir,it work fine

OriginalGriff 22-Aug-14 2:05am

You're welcome!