The data base cannot be opened because it is version 661. This server supports version 655 and earlier.

Question

Hi

Not sure its the correct forum, but i'll try any way:

windows 7 32-bit

ms sql server 2008 

i have a data base i've been working on, its been working fine

on my school computer (which i believe it has the same version of sql, but i can only check it on Monday)

i am trying to attach the mdf file form my data base in my home computer but getting this message:

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

i had express edition but uninstalled it and installed the regular edition

still doesn't work...

any idea?

Answer 1

Hello,

Database version 661 means that the database was from a SQL Server 2008 R2 instance, where version 655 means SQL Server 2008 instance. You'll need to install the R2 version and continue to use that version. If you want to use a plain 2008 instance, you'll still have to install an R2 instance, then script your objects + data out to the 2008 instance.

In SQL Server you CAN'T downgrade versions, as in your example from 2008 R2 (10.50) to 2008 (10.00) but you can upgrade versions.

-Sean

Answer 2

Hey buddy, I'm getting the same error. All over the internet, the solution seems to be exactly what you're saying. The only problem in my case is that I already have SQL Server Management Studio 2008 R2 installed on my system. And just today, I also installed SQL Server 2008 R2. Why am I still getting this error?

 

Also, when I checked the connection properties, is said

Product Name : Microsoft SQL Server Express Edition (64-bit)

Product Version : 10.0.2531 SP1

 

Not sure if this info is helpful. Just thought I'd mention it. Might further aid you in solving my problem. 

Answer 3

Hey buddy, I'm getting the same error. All over the internet, the solution seems to be exactly what you're saying. The only problem in my case is that I already have SQL Server Management Studio 2008 R2 installed on my system. And just today, I also installed SQL Server 2008 R2. Why am I still getting this error?

 

Also, when I checked the connection properties, is said

Product Name : Microsoft SQL Server Express Edition (64-bit)

Product Version : 10.0.2531 SP1

 

Not sure if this info is helpful. Just thought I'd mention it. Might further aid you in solving my problem. 

That's because 10.0.2531 is SQL Server 2008, not SQL Server 2008R2. R2 would be 10.50. for it's version.

-Sean

Answer 4

I already has R2 installed (10.50.2500.0), but also have this problem.

Xiao