none
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?

    Saturday, December 24, 2011 5:31 PM

Answers

  • 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

    Saturday, December 24, 2011 6:18 PM
    Answerer

All replies

  • 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

    Saturday, December 24, 2011 6:18 PM
    Answerer
  • 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. 

    • Edited by Dragster93 Wednesday, January 25, 2012 10:33 AM
    Wednesday, January 25, 2012 10:29 AM
  • 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

    Wednesday, January 25, 2012 1:15 PM
    Answerer
  • I already has R2 installed (10.50.2500.0), but also have this problem.

    Xiao

    Wednesday, February 29, 2012 9:25 AM