SQL DATA连接问题 [英] SQL DATA Connection Problem

问题描述

在那里

当我尝试在vs2010中连接sql数据库时，它给出了错误...

错误是...
无法打开数据库"，因为它是661版.此服务器支持655及更早版本.

我会尽力打开它.
我只想查看表和存储过程等.我不想将其与任何项目连接.

请给我有关此问题的解决方案.

hi there

when i trying to connect sql database in vs2010 then it gives error...

error is...
The Database '' '' cannot be opened because it is version 661. This server support version 655 and earlier.

i try my best to open it.
i want to only see tables and stored procedures etc. i dont want to connect it with any project.

please give me a solution about it.

推荐答案

SQL Server 2008数据库为655版本.SQLServer 2008 R2数据库为661.您正在尝试附加2008 R2数据库(v.661)到2008年的实例，不支持此功能.数据库升级到2008 R2版本后，就无法降级.您必须将您的2008 SP2实例升级到R2，或者必须将该数据库中的数据复制到2008数据库中(例如，使用数据迁移向导或类似的方法).

该消息至少可以说是误导性的，它说的是662，因为SQL Server 2008 SP2确实

SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661. You are trying to attach an 2008 R2 database (v. 661) to an 2008 instance and this is not supported. Once the database has been upgraded to an 2008 R2 version, it cannot be downgraded. You''ll have to either upgrade your 2008 SP2 instance to R2, or you have to copy out the data in that database into an 2008 database (eg using the data migration wizard, or something equivalent).

The message is misleading, to say the least, it says 662 because SQL Server 2008 SP2 does support 662 as a database version,[^] this is when 15000 partitions are enabled in the database, see Support for 15000 Partitions.docx. Enabling the support bumps the DB version to 662, disabling it moves it back to 655. But SQL Server 2008 SP2 does not support 661 (the R2 version).

看看类似的讨论:
SQL Server:附加错误的版本661 [版本661.此服务器支持版本655 [在此处检查 [ ^ ]

Have a look on similar discussion:
SQL Server: attach incorrect version 661[^]
Version 661. This Server supports version 655[^]

More detailed description with snaps:
Check here[^]

这篇关于SQL DATA连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！