Post reply

rename default instance

  • February 29, 2008 at 10:08 am

    #76915

    I install sql 2000 with no issue but I want to change the name of the default instance from local to the server name.

    How can I accomplish this goal?

    Thanks

  • February 29, 2008 at 10:19 am

    #783944

    select @@servername should return the name of your server in which case I'm assuming you just want to change the registration properties within EM? You can delete the registration in EM for server (local) and create a new registration with your servername.

    Tommy

    Follow @sqlscribe

  • February 29, 2008 at 12:43 pm

    #784007

    The server should always respond to both the windows server name and (local). You don't remove or rename a default instance.

    If you are talking about the client tools, follow Tommy's advice.

  • February 29, 2008 at 12:50 pm

    #784011

    thank you for the information, thanks to the post I resolved the issue.

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

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