Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

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

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

chengy
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 :
SQLServer2005SQLBrowserUser$LAMDAMIRROR1A
SQLServerDTSUser$LAMDAMIRROR1A
SQLServerMSSQLServerADHelperUser$LAMDAMIRROR1A
SQLServerMSSQLUser$LAMDAMIRROR1A
SQLServerSQLAgentUser$LAMDAMIRROR1A

There are also Registry entries containing the old 'LAMDAMIRROR1A' name. Does this matter ? Should this be changed ?
eg.
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.
etc

tommyfly
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]
"GroupPrefix"

Thanks,
Tom
Go to Top of Page

tommyfly
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:
http://social.msdn.microsoft.com/Forums/br/sqldatabaseengine/thread/9942c0aa-c6f5-4629-96d4-1534307c61c9

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  
 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