SQL Server Performance Forum – Threads Archive
how to rename sql server 2005 instanceIs 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, referhttp://msdn2.microsoft.com/en-us/library/ms178083.aspx 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.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
You can use Sp_dropServer and Sp_addserver AKTHAR