Post reply

Rename a Named Instance in a 2008 R2 Cluster

  • November 29, 2012 at 11:40 am

    #393702

    Hi.

    I have a 2 Node active\passive windows cluster with 2 SQL Server 2008 R2 Instances. One Default instance and 1 named Instance.

    Default Instance is named KOCSQL02DI

    1st Named Instance is named KOCSQL02DI1\AML

    I would like to change the name of the KOCSQL02DI1\AML to KOCSQL02DI1\Sharepoint

    Is there a way to do this or am I better of removing the named instance entirely and re-installing with the new name?

  • November 29, 2012 at 12:10 pm

    #1563967

    you are correct;

    there is no way to rename an instance; you have to install a new one with the new name, and drop the old when when you are ready.

    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!

  • November 29, 2012 at 1:05 pm

    #1564001

    Thank you Sir!

Viewing 3 posts - 1 through 2 (of 2 total)

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