The database version 661 cannot be enabled. This server supports both version 655 and earlier. The downgrade path is not supported.

I like the vs2010 interface, so I installed the win7 flagship version, a brand new system, and then installed vs2010, which brought a series of troubles.

 

Sql2008 SP1 express and SQL 2008 R2 (RTM)

Vs2010 uses sql2008 SP1 Express. Check that the sql2008 SP1 version is 10.0.2531.0, as follows:

Use master

Select @ version

--

Microsoft SQL Server 2008 (SP1)-10.0.2531.0 (Intel x86) Mar 29 2009 10:27:29 copyright (c) 1988-2008

Microsoft Corporation Express edition on Windows NT 6.1 <x86> (build 7600 :)

 

After running my program on vs2010, I encountered a problem when I took the program home. XP + vs2008 + sql2005 Express at home. The result showed that "the database version is 655 and cannot be opened, this server supports version 612 and earlier, but does not support downgrading paths.

 

After the query, the database is automatically upgradedVersion 655, that is, sql2008 SP1.

 

The home machine is a little slow, does not run win7, do not want to upgrade to vs2010, so we had to maintain vs2008, upgrade sql2005 express to sql2008 Express.

When upgrading, we can see that sql2008 R2 was released, so we directly upgraded sql2005 in our house to sql2010 R2 RTM. The version is:

Microsoft SQL Server 2008 R2 (RTM)-10.50.1600.1 (Intel x86)

It took some time to install vs2008 SP1 during the upgrade and finally completed sql2008 R2 (RTM) express + SQL Server Management studio Express.

 

As a result, a new problem occurs after the program is taken from the house to the unit: "The database version is 661 and cannot be opened. This server supports both version 655 and earlier. The downgrade path is not supported ."

 

I was dizzy. I learned after the query,661 is the version number of sql2008 r2Then, upgrade sql2008 SP1 express to sql2008 R2 Express. The version number is as follows:

Microsoft SQL Server 2008 R2 (RTM)-10.50.1600.1 (Intel x86) APR 2010 15:53:02 copyright (c) Microsoft

Corporation Express edition with advanced services on Windows NT 6.1 <x86> (build 7600 :)

 

After the problem is solved, should we consider upgrading the sql2005 server in the server to sql2008 R2 ......