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.
    znadeem, Jun 27, 2007
    #2

  2. satya Moderator

    satya, Jun 28, 2007
    #2

  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.
    MohammedU, Jun 28, 2007
    #2

  4. Akthar New Member

    You can use Sp_dropServer and Sp_addserver

    AKTHAR
    Akthar, Jun 29, 2007
    #2

Share This Page