Post reply

Renaming a Named Instance

  • January 31, 2012 at 9:14 pm

    #391443

    Is it possible to rename a named instance..?

    If yes, are there any issues..?

  • January 31, 2012 at 9:19 pm

    #1441029

    No, you can't rename the named instance.

    BOL:

    They can be used only to rename the part of the instance name that corresponds to the computer name. For example, you can change a computer named MB1 that hosts an instance of SQL Server named Instance1 to another name, such as MB2. However, the instance part of the name, Instance1, will remain unchanged. In this example, the \\ComputerName\InstanceName would be changed from \\MB1\Instance1 to \\MB2\Instance1

  • January 31, 2012 at 9:25 pm

    #1441030

    Thanks Padhis..!

    I am not able to find an installer file for the below mentioned version.. (In order to create a named instance..I need the install files right..?).

    Can you help me..?

    Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

  • January 31, 2012 at 9:30 pm

    #1441031

    Yes you need a installer (setup) file .

  • June 27, 2013 at 2:17 pm

    #1628129

    Ok, I have the setup/install files. What now? Where do I go in the installation options to rename the instance, not the computer?

    Thanks for any input.

  • June 27, 2013 at 2:39 pm

    #1628134

    donluz (6/27/2013)

    Ok, I have the setup/install files. What now? Where do I go in the installation options to rename the instance, not the computer?

    Thanks for any input.

    you cannot rename an instance.

    you can create a new instance with the desired name, migrate settings manually via scripts, bakcup and restore user databases, and finally uninstall the old one.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 27, 2013 at 2:53 pm

    #1628137

    This would break any code that references the instance name, any linked servers, ODBC connections or connection strings in connecting applications out there. There a lots of gotchas so I would avoid this if possible.

  • August 28, 2013 at 12:40 pm

    #1645707

    Geez, I was hoping instance could be renamed . Just to confirm Gurus ,you can't do the following even in 2012

    sp_dropserver 'Server Name\old_instance_name'

    go

    sp_adderver 'Server Name\New_instance_name'

    go

  • August 31, 2013 at 1:15 am

    #1646538

    Yes, we can rename the instance by using the below commands. I have also involved once in this activity.

    sp_dropserver 'old servername'

    go

    sp_addserver 'new servername'

    go

    Thanks,
    I’m nobody but still I’m somebody to someone………….

  • August 31, 2013 at 4:44 am

    #1646552

    Again, you cannot rename an instance.

    The sp_dropserver/sp_addserver applies whem you have changed the machine name in Windows. In this case you need to do "sp_dropserver oldname" followed by

    sp_addserver "newname", local

    to have @@servername to show the correct server name.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • August 31, 2013 at 5:27 am

    #1646554

    SQLAli (8/31/2013)

    Yes, we can rename the instance by using the below commands. I have also involved once in this activity.

    sp_dropserver 'old servername'

    go

    sp_addserver 'new servername'

    go

    That does not rename a named instance. That's needed when the server name has changed (so SomeServer\SQL01 to SomeOtherServer\SQL01). You cannot in any way change the name of a named instance (short of uninstalling the whole thing and reinstalling with a new name)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 11 posts - 1 through 10 (of 10 total)

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