Server Name (local)

  • Hopefully a simple question, but I want to rename my server from the actual servername, to (local).

    I have used the following code to rename with success, but how do I register it not hardcoded with the name but with (local)?

    EXEC sp_dropserver 'oldname'

    GO

    EXEC sp_addserver 'newname', 'local'

    GO

    Thanks!

  • Where are you "registering" the local name ?


    Mathew J Kulangara
    sqladventures.blogspot.com

  • Sorry, should have given more info.

    I am doing this on the actual server itself.  It is a brand new SQL install that the Network Admin put together.  I have to change a few things and am not adverse to reinstalling.  Everything looks fine but I want to register it with (local) and not the actual server name.

    Hopefully that answers your question properly.  Thanks!

  • I assume you mean you want to register the server in Enterprise Manager (EM). Registering the local server as (local) in EM can

    be done regardless of the server name the you or the NetAdmin specified.

    First, did you restart SQL Server after executing sp_dropserver and sp_addserver? A restart is required for those changes to take effect.

    After the restart, remove the server registration from EM. Then, re-register the server using (local). Either type it in directly or click the [...] button and select it from the listbox. It should be the first item in the list.

  • Got it!  Easy, thanks so much!

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

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