DB 无法打开，因为它是版本 655。此服务器支持版本 612
我正在尝试做 70-515 考试的一些练习。不幸的是，我在尝试将 Northwind 连接到网格控件时失败了。这将导致： NORTHWND.MDF' 无法打开，因为它是版本 655。此服务器支持版本 612 及更早版本。不支持降级路径。
我使用 Windows 7 Home 和 MS Visual Web Developer 2010 Express。据我了解此错误，我的系统上的 SQL Express 一定是旧版本。我从此处下载并安装了 SQL Express 2008r2。没有效果。从其他来源我发现我可能需要更改实例名称：工具 ->选项->数据库工具->数据连接-> SQL Server 实例名称。那里写着SQLEXPRESS。我不知道还应该在那里插入什么？
I'm trying to do some excercises from exam 70-515. Unfortunately I fail while trying to attach Northwind to a grid-control. It would result in:NORTHWND.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
I use Windows 7 Home and MS Visual Web Developer 2010 Express. As fas as I understand this error, SQL Express must be an old version on my system. I downloaded and installed SQL Express 2008r2 from here. No effect. From other sources I figured out that I might need to change the instance name: Tools -> Options -> Database Tools -> Data Connections -> SQL Server Instance Name. There it is written SQLEXPRESS. I don't know what else I should insert there?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（7）
事实证明，卸载 SQL Express 并重新安装最新版本可以解决该问题。我在安装时选择 SQLSERVER2008 作为实例名称，并在 Visual Studio 中进行设置，如上所述。
Turns out that deinstalling SQL Express and reinstall the latest version fixed the problem. I chose SQLSERVER2008 as Instance-Name while installing and set it in Visual Studio as described above.
转到服务控制面板并查找名为
SQL Server (XXX)的服务 - 该XXX是该服务正在运行的实例的名称。您只需找到您安装的 2008R2 实例并将其键入“SQL Server 实例名称”框中即可。Go to the Services control panel and look for a service named
SQL Server (XXX)-- thatXXXis the name of the instance that service is running. You just have to find the 2008R2 instance that you installed and type that into the "SQL Server Instance Name" box.可能有助于尝试更改兼容性级别，以确保其向后兼容。
验证它是什么级别
然后使其与旧版本兼容
默认情况下，Sql Server 2014 将使用
@ 将数据库版本兼容性更改为仅 2014 @version你应该能够知道 Sql Server 是哪个版本。然后运行上面的命令将其更改为您拥有的版本。
附加步骤：确保您查看数据库的可访问性没有重置，通过右键单击文件夹和数据库的属性来执行此操作。 （确保您拥有权限，以免访问被拒绝）
Might help to try to change the compatibility level, to make sure its backwards compatible.
Verify what level it is
Then make it compatible with the older version
By default, Sql Server 2014 will change the db versions compatibility to only 2014, using the
@@ versionyou should be able to tell, which version Sql Server is.Then run the command above to change it the version you have.
Additional step: Ensure you look at the accessibility of the DB is not reset, do this by right clicking on properties of the folder and the database. (make sure you have rights so you don't get an access denied)
我读了这篇文章，但没有任何帮助我。然后我尝试了其他一些选择。
我发现有效的方法是从原始数据库导出数据库和存储过程。然后将它们上传到第二个数据库（第二台计算机）。
首先导出DB内容（数据） - 我使用SQL Server导出数据向导。在要导出的数据库上右键单击，然后选择任务，然后导出数据。按照说明并以最适合您的格式保存 - 我使用 Excel 保存数据。
然后再次右键单击数据库名称导出存储过程。选择任务，这次选择生成脚本。再次按照向导的说明进行操作。
要导入数据，只需转到第二台计算机并右键单击您想要将数据导入到的数据库即可。再次任务>导入数据。按照说明从数据库导入所有数据。
最后，为了导入存储过程，我打开了一个新的存储过程命令，并将之前保存它们的脚本文件拖放到此窗口中。新的存储过程窗口充满了我的存储过程的整个列表。最后更改 SP 将使用的数据库名称（如果这与原始数据库名称不同）。 （这是第一行 USE [DBName]。然后只需执行，SP 将完全恢复。
这帮助我很快地恢复了整个数据库并再次运行。希望这会有所帮助。
I read this post but nothing helped me. Then I tried a few other options.
The way that I found that worked was to export the database and stored procedures from the original database. Then upload them into the second database(second computer).
Firstly export the DB content (data) - I used SQL server export data wizard. on the database you wish to export from right click then choose tasks, then export data. Follow the instructions and save in whichever format is best for you - I used excel for the data.
then to export the stored procedures rightclick the database name again. choose tasks and this time choose generate scripts. again follow the instructions of the wizard.
To import the data simply go to the second computer and right click the database you wish to import the data into. again tasks > import data. Follow the instructions to import all of the data from the database.
Finally to import the stored procedures, I opened up a new stored procedures command and dragged and dropped the script file that I had previously saved them in and dropped it into this window. The new stored procedure window filled with the entire list of my stored procedures. Finally change the name of the database name that will be used by the SP ( if this is different from the original DB name). (This is the first line USE [DBName]. then simply execute and the SP's will be fully restored.
This has helped me get my entire database up and running again very quickly. Hope this helps.
SQL Management Studio 与 SQL Server 版本（或数据库版本）不同。示例：目前，我的工作计算机有 SQL Server 2012 Management Studio，但 SQL 版本是 9.0 – 即 SQL Server 2005。SQL Management studio 只是一个 IDE（集成开发环境），与 SQL Server 版本不相同。
如果当您尝试附加数据库时，如果收到类似于以下内容的错误：
这意味着您尝试附加的数据库是使用较新 SQL 版本创建的，然后您的计算机所拥有的版本将无法使用它。查看他们是否拥有使用您的计算机使用的相同或更早版本的 SQL Server 创建的数据库。在本例中，我找到了使用 SQL Server 2005（版本 9）创建的相同数据库。
要快速检查计算机正在运行的 SQL Server 版本，请从Windows 桌面转到任务管理器 (Ctrl+Shift+Esc)，单击 >进程选项卡，找到并选择名为“sqlservr.exe”的条目，右键单击并选择属性，单击详细信息 > 选项卡查看产品版本（例如 9….）或文件版本（文件版本说明年份和版本 - 例如 2005.9…）。
确实，这与我得到的错误相同，但直到现在我还没有解决问题！
The SQL Management Studio is different than the SQL Server Version (or Database version). Example: At the current time, my work computer has SQL Server 2012 Management Studio but the SQL Version is 9.0 – which is SQL Server 2005. The SQL Management studio is only an IDE (Integrated Development Environment) and is NOT the same as the SQL Server version.
If when you try to Attach a Database, if you get an error similar to the following:
It means that the Database that you are trying to Attach was created with a Newer SQL version then what your computer has and you will NOT be able to use it. See if they have that Database that was created with the same or earlier version of SQL Server that your computer uses. In this case, I found the same Database that was created with SQL Server 2005 (Version 9).
A quick way to check what SQL Server version the computer is running, from the Windows desktop, go to Task Manager (Ctrl+Shift+Esc), click on the Processess tab, find and select the entry named “sqlservr.exe”, right click and choose Properties, click on the Details tab look at Product Version (Ex. 9….) or File Version (File version states the year and the version - Ex. 2005.9…).
Really this is the same error that i get, but until now i did not solve the problem!!
转到
工具>选项>数据连接，如果您已安装 SQL Server Express 2008r2，请将 SQL Server 实例名称留空。Go to
Tools>Options>Data Connections, provided you have installed SQL Server Express 2008r2, leave the SQL Server instance name blank.当您尝试使用 SQLServer Express 连接到 MDF 文件时会发生这种情况。要解决此问题，您需要转到
Services.msc并打开 SQL Server 服务。您需要设置登录属性，当服务启动时，您将能够毫无问题地连接到 MDF 文件。This happens when you are trying to use the SQLServer Express to connect to the MDF file. To remedy this issue, you need to go to
Services.mscand turn on SQL Server services. You need to set the log on properties and when the service is started, you will be able to connect to the MDF file without any issues.