January 31, 2006 at 9:56 am
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!
January 31, 2006 at 12:45 pm
Where are you "registering" the local name ?
Mathew J Kulangara
sqladventures.blogspot.com
January 31, 2006 at 1:35 pm
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!
February 1, 2006 at 7:00 am
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.
February 1, 2006 at 10:24 am
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