SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Renaming SQL 2008 R2 server - Windows Groups?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

3 Posts

Posted - 10/03/2012 :  11:18:04  Show Profile  Reply with Quote
A Windows 2003 server has been renamed from LAMDAMIRROR1A to LAMDAMIRROR2A and the following sql has been run in SQL Server 2008 R2 on the server :
exec sp_dropserver 'LAMDAMIRROR1A'
exec sp_addserver 'LAMDAMIRROR2A','local'

However, although everything appears ok, the 5 Windows 2003 Groups (automatically created by the SQL 2008 R2 Install) still contain 'LAMDAMIRROR1A' in their name. Does this matter ? Can the Windows Groups be just renamed (right click , rename) or will this cause problems ?
The Windows Groups are :

There are also Registry entries containing the old 'LAMDAMIRROR1A' name. Does this matter ? Should this be changed ?
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Machines\OriginalMachineName.
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services\Report Server\GroupPrefix.
My Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\printers\Microsoft XPS DocumentWriter\DsSpooler\serverName.

Starting Member

United Kingdom
2 Posts

Posted - 12/14/2012 :  04:36:52  Show Profile  Visit tommyfly's Homepage  Reply with Quote
Hi Chengy,

Have you gotten any further with this? I renamed a server and all seemed fine until I created a replication publication and I saw an error that the old server name could not be found.

In addition to the registry entries you listed I see the following as unchanged:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services\SSIS Server]

Go to Top of Page

Starting Member

United Kingdom
2 Posts

Posted - 12/14/2012 :  05:15:36  Show Profile  Visit tommyfly's Homepage  Reply with Quote
After a little more research I found the following post on the MSDN boards:

It basically states that the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Machines] "OriginalMachineName" registry key can be changed manually.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000