SQL Server Performance Forum – Threads Archive
Renaming a named instance of SQL Server 2005
I have a server with 7 named instances running on it. I am wanting to rename one of the instances. I’ve tried this: Sp_dropserver orion-dbcent1bKIOWACENTRALGO
Sp_addserver orion-dbcent1bJEFFERSONCENTRAL, local
GO but am getting this returned to me: Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘-‘.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘-‘. the computer name is correct
You can’t rename the instance by just running these procedures… you have uninstall and reinstall to get the different instance name… To resolve this error use Square Brackets []
Sp_dropserver [orion-dbcent1b]KIOWACENTRAL
GO
Sp_addserver [orion-dbcent1b]JEFFERSONCENTRAL, local
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Is this SQL 2005 or 2000? Yes. You can change the name of an instance as long as the server is not clustered. For more information, visit thishttp://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx link. Also you can rename a default instance of the database engine just by renaming the computer. See the topic "How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005" in BOL. You cannot rename the instance part of a named instance. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thanks for the help, it is 2005 and I just removed the instance and built a new one.
quote:Originally posted by satya
Is this SQL 2005 or 2000?
Yes. You can change the name of an instance as long as the server is not clustered. For more information, visit thishttp://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx link.
Also you can rename a default instance of the database engine just by renaming the computer. See the topic "How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005" in BOL. You cannot rename the instance part of a named instance.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I don’t think there is any option to change the instance name from ServerAInstA to ServerAInstB….
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>