how to rename sql server 2005 instance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to rename sql server 2005 instance

Is it possible to change ‘servernamesqlserver2005’ to just ‘sqlserver2005’? I just don’t want physical server name before the instance name. is this possible? I need to make this change on virtual server (sql server 2005 cluster machine) with 4 nodes Thanks.
Zafar.
A trip to SQL 2005 books online would get you this, referhttp://msdn2.microsoft.com/en-us/library/ms178083.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.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 you rename the named instance…without the servername is possible unless you change the virtual server name to sqlserver2005… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
You can use Sp_dropServer and Sp_addserver AKTHAR
]]>