Post reply

How to change Sql instance name?

  • September 26, 2008 at 11:59 am

    #194162

    I want to change the instance name of a Sql 2K server from Server1\Instance1 to Server1\Instance2. How can i achieve this without rebuilding the server. Please help.

    I want to keep the server name the same but change the instance name.

    Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.

  • September 26, 2008 at 3:34 pm

    #877994

    Folks, any replies... Thanks.

    Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.

  • September 26, 2008 at 3:58 pm

    #878000

    Unfortunately no, you can not rename an instance. You'd have to tear down and rebuild. I've heard it can be done, but is not advisable ... due to all the registry dependencies.

    Also, use the search feature before posting and/or search Google. This is a very commonly asked question.

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

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