Post reply

Named Instance

  • July 2, 2009 at 8:35 am

    #202016

    Hi ,

    If the SQL Server 2005 default instance is renamed, should we rename the named SQL instance?

    Could you tell me how to do this?

    Thank you,

    Yours

    SQL Buddy

  • July 2, 2009 at 8:40 am

    #1019193

    I dont think renaming an instance is possible. You can install a fresh named instance.


    Pradeep Singh

  • July 2, 2009 at 8:52 am

    #1019210

    --For default instances

    sp_dropserver old_name

    GO

    sp_addserver new_name, local

    GO

    --for Named instances

    sp_dropserver old_servername\instancename

    GO

    sp_addserver new_servername\instancename, local

    GO

    Sonal.

  • July 2, 2009 at 9:08 am

    #1019222

    Hi Sonal,

    Thank you very much for your reply.

    I really appreciate that.

    Yours

    SQL Buddy

  • July 2, 2009 at 12:45 pm

    #1019401

    You're not really renaming the instances; you're renaming the machine that the instances reside on. You also have to stop and start the SQL Server service after running the stored procedures.

    Greg

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

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