Post reply

To change SQL Server 2008 Instance name

  • August 11, 2010 at 1:58 pm

    #387557

    Hi,

    I have change the instance name by using

    sp_dropserver 'SER1\INST1'

    go

    sp_addserver 'SER1\NEWINST1','local'

    I am geting new name by

    sp_helpserver and

    select @@servername as well

    and I have restarted server too.

    But I am not able to connect with new name 'SER1\NEWINST1' from SSMS. (I am able to connect with old name 'SER1\INST1' from SSMS. )

    I am getting following error

    …...provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified…..

    Is there I am missing anything?

    Thanks in advance for your help.

    Vinod

  • August 11, 2010 at 2:14 pm

    #1205707

    Does the error log show the new name as being listed? Just a question, you did change the Windows host name, correct?

  • August 12, 2010 at 8:33 am

    #1206045

    Also I would suggest to run DNSFlush.

  • August 13, 2010 at 12:52 am

    #1206421

    As Steve mentioned you need to change the machine name

    or

    Create an alias with ur desired name but using this still wont change the exact name of server.

  • August 13, 2010 at 1:17 am

    #1206433

    My understanding of those procedures is that they are for renaming a server not the instance.

    Thus it would be like the following:

    When you have more than one instance of SQL Server on the computer, change the sysservers system table information by running the stored procedures this way:

    sp_dropserver old_servername\instancename

    GO

    sp_addserver new_servername\instancename, local

    GO

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 13, 2010 at 1:16 pm

    #1206896

    That was my understanding too Cirq, about those proc's.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply