如何修改 SQL Server 中的实例名 ？

Question

RT
想修改实例名，不要重装，找了好多但都不行。。。
http://msdn.microsoft.com/zh-cn/library/ms143799.aspx

sp_dropserver <old_name\instancename>

GO

sp_addserver <new_name\instancename>, local

GO

不能通过以下步骤重命名 SQL Server 实例。这些步骤只能用于重命名实例名中与计算机名称对应的部分。

高手帮忙，谢先！

Answer 1

Can't change instance name. Can change server name although, so works for default instance only. 

Answer 2

the following link may be helpful
http://topic.csdn.net/t/20031124/09/2487196.html

Answer 3

目前没有办法修改命名实例的实例名
默认实例的名称与计算机名保持一致, 改计算机名会同时改默认实例的名字

Answer 4

SQL Server实例名不能更改的，默认的SQL Server实例名与计算机名相同，如果是命名实例的话，那么实例名就是: 计算机名\指定命名

建议你可以考虑安装多个实例。

Answer 5

thx all !
想了解一下为什么微软不让修改实例名啊？
另外增加实例还需要购买版权么？

Answer 6

You can refer FAQ http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx.  It contains below Q/A:

Q.  How does licensing work with the multi-instance feature in SQL Server 2008?

A.  

You can run multiple instances of SQL Server 2008 on a single computer. Multiple instances are used by organizations that have several applications running on a server but want them to run in isolation so that any problem in one instance will not affect the other instances. In SQL Server 2008, you can run multiple instances with the Workgroup, Standard, and Enterprise editions when they are licensed server/CAL or on a per-processor basis.  Please read the SQL Server 2008 Licensing Overview for more information.

Answer 7

You can refer FAQ http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx.  It contains below Q/A:

Q.  How does licensing work with the multi-instance feature in SQL Server 2008?

A.  

You can run multiple instances of SQL Server 2008 on a single computer. Multiple instances are used by organizations that have several applications running on a server but want them to run in isolation so that any problem in one instance will not affect the other instances. In SQL Server 2008, you can run multiple instances with the Workgroup, Standard, and Enterprise editions when they are licensed server/CAL or on a per-processor basis.  Please read the SQL Server 2008 Licensing Overview for more information.

---

KeLiu