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.
A trip to SQL 2005 books online would get you this, refer Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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 All postings are provided “AS IS” with no warranties for accuracy.

You can use Sp_dropServer and Sp_addserver AKTHAR