Post reply

Rename default instance, 2000

  • September 22, 2006 at 10:55 am

    #62722

    Is is possible to rename a default instance in 2000 and how?

  • September 23, 2006 at 3:20 pm

    #662092

    If you have running only default instance on the Server you can use the below query

    USE Master

    GO

    sp_dropserver current_server_name

    GO

    sp_addserver new_server_name, local

    GO

    And makesure that this is not cluster environment.

    After doing these, you need to re-start the services then only the New Server Name comes into effect. 

    Thanks-Mubeen

  • September 23, 2006 at 6:38 pm

    #662098

    Thank you, for the information.

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

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