使用2012安装SQL Server 2005在同一台机器上... [英] Install SQL Server 2005 on same machine with 2012...

问题描述

我已经在我的系统上安装了sqlserver 2012，现在我的客户端项目数据库是sqlserver 2005 ..安装sqlserver 2012后是否可以安装sqlserver 2005？

Hi,
I have already installed sqlserver 2012 on my system,now my client project database is sqlserver 2005 ..Is it possible to install sqlserver 2005 after installing sqlserver 2012?

推荐答案

好吧，为什么要这样做，它可能无法支持向后兼容性。

解决问题的方法只需 Google [ ^ ]。 ;）



-KR

Well yeah, why to do that, there might be possibility that it could not support backward compatibility.
Solution towards your problem is simply on Google[^]. ;)

-KR

您好，



优先总之，SQL Server 2012可以轻松处理2005数据库（正如Kornfeld已经说过的那样）。但是如果你需要在同一操作系统上运行的SQL Server 2012和2005实例（由于向后兼容性或其他原因），那么我可以这样说：



1。如果您的操作系统是 Windows Server 2012或Windows 8，那么答案可能是。为什么？根据Microsoft的说法：Windows Server 2012 R2，Windows Server 2012，Windows 8.1或Windows 8不支持SQL Server 2005（发行版和服务包）和早期版本的SQL Server。

但我已经看到了一些解决方法（我没有尝试过）。链接：

a。 在Windows 8上安装SQL 2005 Developer [ ^ ]

b。 如何在Windows 8中安装SQL Server 2005 Express [ ^ ]



2.好吧，如果您的操作系统不是Windows Server 2012或Windows 8，那么您可以这样做。 Microsoft确认如果您已安装SQL Server 2012，则可以安装SQL Server 2005并将它们并排运行。 SQL Server 2005和2012实例可以同时运行，我可以根据自己的经验确认。在您的情况下，您可能会在安装过程中收到一些错误消息。如果发生这种情况，你需要处理它们。



顺便提一下，我建议你只安装SQL Server 2005数据库引擎并使用SQL Server 2012管理工作室管理这两个实例（2012年和2005年）。



如果您需要进一步的帮助，请告诉我。

Hi,

First of all, SQL Server 2012 can handle 2005 databases easily (as Kornfeld already said this). But if you need SQL Server 2012 and 2005 instances running on the same operating system (because of backward compatibility or other reasons), then I can say this:

1. If your operating system is Windows Server 2012 or Windows 8, then the answer is maybe. Why? According to Microsoft: "SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8."
But I have seen some workarounds for this (I haven't tried them). Links:
a. Install SQL 2005 Developer on Windows 8[^]
b. How to install SQL Server 2005 Express in Windows 8[^]

2. Well, if your operating system is not Windows Server 2012 or Windows 8, you can do that. Microsoft confirms that if you have installed SQL Server 2012, you can install SQL Server 2005 and run them side-by-side. SQL Server 2005 and 2012 instances can run at the same time and I can confirm that from my own experience. In your case, you may get some error messages during installation. If that would happen, you need to deal with them.

By the way, I would advise you to install SQL Server 2005 database engine only and use SQL Server 2012 Management Studio to manage both instances (2012 and 2005).

Please let me know if you need further help.

这篇关于使用2012安装SQL Server 2005在同一台机器上...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！