安装新的SQL Server实例 [英] Install a New Instance of SQL server

问题描述

我有一个Windows服务器，其中包含为特定部门安装的SQL服务器。

我想要将我的数据库添加到sql server但是，管理员拒绝了，因为这个sql server服务于另一个部门，他说我需要安装自己的服务器。



我的问题是：我可以在同一台服务器上为我的部门安装sql server而不影响他们的数据库吗？如果我再次安装sql server，是否会覆盖他们的sql server？如果不是我该怎么办？有什么特别的或任何选择让我这样做？



谢谢，

Missa

Hi,

I have a windows server that contains an sql server installed on it for a specific department.
I want to add my database to the sql server but, the admin refused because this sql server serves another department and he said I need to install my own server.

My question is: can I install sql server for my department on the same server without affecting their databases? if I installed the sql server again, will it overwrites their sql server or not? if not how can I do that? is there something special or any option to allow me to do that?

Thank you,
Missa

推荐答案

安装SQL期间服务器会询问您实例名称。如果你给它一个新名称，它将安装一个单独的实例而不是它们正在使用的实例。



听起来你的管理员反应过度，但也许他们有一个政策到位这需要这个。



只需完成安装并输入一个新的实例名称就可以了。它不会影响（除了磁盘空间和其他资源）另一个SQL。

During the install of SQL server it will ask you for an instance name. If you give it a new name it will install a separate instance than what they are using.

It sounds like your admin is overreacting but perhaps they have a policy in place that requires this.

Just go through the install and put in a new instance name and you'll be fine. It won't affect (other than disk space and other resources) the other SQL.

这篇关于安装新的SQL Server实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！