SQL Server Performance

how to rename sql server 2005 instance

Discussion in 'SQL Server 2005 Clustering' started by znadeem, Jun 27, 2007.

  1. znadeem New Member

    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.
  2. satya Moderator

  3. MohammedU New Member

    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.
  4. Akthar New Member

    You can use Sp_dropServer and Sp_addserver

    AKTHAR

Share This Page