I´m deploying my database to a SQL Server 2008 R2 Express instance that my software also installs. Everything works fine, but on certain target machines there are other instances of SQL Server 2008, 2005, 2000...I know that, theoretically, SQL Server instances may coexist side-by-side. But I also know that there are several conflicts between them. Internet is full of them.
我正在将我的数据库部署到我的软件也安装的SQL Server 2008 R2 Express实例。一切正常,但在某些目标机器上还有SQL Server 2008,2005,2000的其他实例......我知道,从理论上讲,SQL Server实例可以并存。但我也知道他们之间存在着一些冲突。互联网充满了他们。
My most common symptom is: server protocols are not installed with a previous installed SQL Server 2008 instance (from other vendor). In SQL Server Configuration Manager, under "SQL Server Network Configuration", the item "Protocols for 'MyInstance'" is just missing. So any client machine can connect to server.
我最常见的症状是:服务器协议未安装以前安装的SQL Server 2008实例(来自其他供应商)。在SQL Server配置管理器中的“SQL Server网络配置”下,缺少“MyInstance的协议”项。所以任何客户机都可以连接到服务器。
I´d like to minimize the visits to clients house and make my application as self-deployable as possible. Is there something I can do to avoid or resolve instances conflicts? Any advice? Am I wishing for something impossible?
我希望尽量减少对客户的访问,并使我的应用程序尽可能自我部署。我能做些什么来避免或解决实例冲突?任何建议?我想要一些不可能的东西吗?
1 个解决方案
#1
3
You probably will want to read up on what versions can live on the same server/client:
Working With Multiple Versions and Instances of SQL Server
Work with Multiple Versions and Instances of SQL Server
您可能希望了解哪些版本可以存在于同一服务器/客户端上:使用SQL Server的多个版本和实例使用SQL Server的多个版本和实例
Both of these links have the chart regarding what side-by-side installs are supported, the second though also includes a little bit more regarding the components and those that will be upgraded to the highest release installed.
这两个链接都有关于支持哪些并排安装的图表,第二个链接还包括有关组件的更多信息以及将升级到安装的最高版本的组件。
With the issue you spoke of with SSCM this can be caused by many things, most of them revolve around a corrupted installation of the management tools; or I mostly see issues with WMI calls on the client. Since most of those settings are available within the registry I would suggest looking at that side to get your instance configured and locked down.
有了您与SSCM谈到的问题,这可能是由许多事情引起的,其中大多数都是围绕管理工具的损坏安装;或者我主要在客户端看到WMI调用的问题。由于大部分设置都在注册表中可用,我建议您查看该方面以配置和锁定您的实例。
You might also look at SQL Server Compact Edition. It is developed as an embeded database that does not require install of the full SQL Server managemnet tools. You have the same API and controlls that come with full version of SQL Server, just a "compact" install. I have interacted with one application that used it but have not done any development with it.
您还可以查看SQL Server Compact Edition。它是作为嵌入式数据库开发的,不需要安装完整的SQL Server managemnet工具。您拥有与完整版SQL Server一样的API和控件,只需“紧凑”安装。我与一个使用它的应用程序进行了交互,但没有对它进行任何开发。
#1
3
You probably will want to read up on what versions can live on the same server/client:
Working With Multiple Versions and Instances of SQL Server
Work with Multiple Versions and Instances of SQL Server
您可能希望了解哪些版本可以存在于同一服务器/客户端上:使用SQL Server的多个版本和实例使用SQL Server的多个版本和实例
Both of these links have the chart regarding what side-by-side installs are supported, the second though also includes a little bit more regarding the components and those that will be upgraded to the highest release installed.
这两个链接都有关于支持哪些并排安装的图表,第二个链接还包括有关组件的更多信息以及将升级到安装的最高版本的组件。
With the issue you spoke of with SSCM this can be caused by many things, most of them revolve around a corrupted installation of the management tools; or I mostly see issues with WMI calls on the client. Since most of those settings are available within the registry I would suggest looking at that side to get your instance configured and locked down.
有了您与SSCM谈到的问题,这可能是由许多事情引起的,其中大多数都是围绕管理工具的损坏安装;或者我主要在客户端看到WMI调用的问题。由于大部分设置都在注册表中可用,我建议您查看该方面以配置和锁定您的实例。
You might also look at SQL Server Compact Edition. It is developed as an embeded database that does not require install of the full SQL Server managemnet tools. You have the same API and controlls that come with full version of SQL Server, just a "compact" install. I have interacted with one application that used it but have not done any development with it.
您还可以查看SQL Server Compact Edition。它是作为嵌入式数据库开发的,不需要安装完整的SQL Server managemnet工具。您拥有与完整版SQL Server一样的API和控件,只需“紧凑”安装。我与一个使用它的应用程序进行了交互,但没有对它进行任何开发。