I've found that the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Machines ---> OriginalMachineName
has an incorrect value. It has the value corresponding to my old server name, I've renamed it and followed the procedure of sp_dropserver 'oldname' sp_addserver 'newname','local'
Have I to correct the key's value?
Yes, please manually edit the value of OriginalMachineName to that of current server name. Also, run this query
from SSMS and verify if it returns the correct machine name, if yes then you are all set.
select serverproperty ('ComputerNamePhysicalNetBios')
Check out my blog
SQLactions.com | This posting is provided “AS IS” with no warranties, and confers no rights.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?