问题描述
亲爱的朋友们,
请建议我如何更改sql server名称,实际上在配置lodshipping时我收到错误14262(指定的服务器名称不存在)。
i已经检查了实例,然后服务器名称的属性与select @@ servername输出不同。
请告诉我如何更改服务器名称。我尝试了谷歌的一些脚本,但我收到语法错误。
Regard's,
Thrilok。
Dear Friends,
please suggest me how to change the sql server name, actually while configuring lodshipping i am getting error 14262 (The specified server name does not exist).
i have checked right click on the instance, then properties there server name is different from select @@ servername output.
Please tell me how to change server name. I tried some script from google but i am getting syntax errors.
Regard's,
Thrilok.
推荐答案
对于承载SQL Server默认实例的重命名计算机,请运行以下过程:
For a renamed computer that hosts a default instance of SQL Server, run the following procedures:
sp_dropserver <old_name>;
GO
sp_addserver <new_name>, local;
GO
重新启动SQL Server实例。
Restart the instance of SQL Server.
For a renamed computer that hosts a named instance of SQL Server, run the following procedures:
sp_dropserver <old_name\instancename>;
GO
sp_addserver <new_name\instancename>, local;
GO
这篇关于如何在2005 Enterprice Edition中更改SQL Server名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!