Incorrect value of OriginalMachineName registry key

Question

Hi all,

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?

Answer 1

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.

If this reply answers your question, please mark is as Answered for others to find it easily. If this reply helps you resolving the problem, please vote the post as Helpful.