Is it possible to rename an SQL Server 2005 instance

exdqitrt 于 2023-02-21 发布在 SQL Server

关注(0)|答案(5)|浏览(153)

I would like to change the name of my SQL Server instance. Is there a simple way of doing this or is a significant effort required? Note, this is a named instance - not the default instance.

sql-server

来源：https://stackoverflow.com/questions/156004/is-it-possible-to-rename-an-sql-server-2005-instance

5条答案

按热度按时间

e5nqia271#

The only way is a reinstall. See this similar thread for more info: SQL Server, convert a named instance to default instance?

赞(0）回复(0）举报 2023-02-21

sdnqo3pr2#

Or you could try this method: http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/544c4eaf43ddfaf3/f1bdcd1ec9cab158#f1bdcd1ec9cab158

赞(0）回复(0）举报 2023-02-21

h4cxqtbf3#

I have seen a few makeshift ways of doing this, but I don't have confidence in any of them. I think I will simply install a new instance and transfer my information over.

赞(0）回复(0）举报 2023-02-21

fdx2calv4#

Renaming does't work well on the registry. Install a new isntance.

赞(0）回复(0）举报 2023-02-21

rwqw0loc5#

Although there is no simple way of renaming a SQL Server instance, one can create SQL aliases .

赞(0）回复(0）举报 2023-02-21