June 22, 2011 at 8:40 am
During the setup of a new production server(after SQL Server install, but before the application databases were created), a decision was made to rename the server. The server admins changed the server name, and the DBAs changed the entry in the master.sys.servers table. However, the registry entry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Machines still shows the original name. This name is showing up in the event viewer when there is any entry for SQL Server.
Would there be any problems if we changed this value to the new server name?
June 22, 2011 at 9:56 am
Does SELECT @@SERVERNAME still show the old server name?
The proper way to have done this is to use sp_dropserver and sp_addserver to properly allow SQL Server to update the server name.
See article here.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 22, 2011 at 10:02 am
@@Servername shows the new name and we did use the sp_dropserver and sp_addserver procedures to change the name. As I stated, the old name is only in the registry entry.
June 22, 2011 at 11:38 am
Brian Brown-204626 (6/22/2011)
@@Servername shows the new name and we did use the sp_dropserver and sp_addserver procedures to change the name. As I stated, the old name is only in the registry entry.
Sorry misread it. Have the permissions changed for that key? SQL Server may have had issue changing that key when the stored procedures where used.
If the only thing you are seeing from it is event viewer I would guess you could try changing it, after backing it up of course. You might also just put SQL Server on a test server and specifically go in and change this key to see if anything in SQL Server is affected. Doing it on test might be better than doing it on a new server you just spent time building.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply