Changing SQL Server name and SQL Server group name
Hi,
I have notice that our dev and prod SQL Server has SQL Server name and SQL Server group name that is different to the machine name.
We are planning to change it to match the machine name. To do this, from what we have read, you change the SQL Server name using the sp stored procedures to drop then re-add server with the machine name, then you change the Windows SQL Server group name replacing any reference to the old machine name with the current machine name, then you drop the SQL Server group and re-add the group. Do I need to do anything else? And most importantly is a common or risky thing to do?
Thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 11, 2009 7:18 AM
UPDATED:
May 20, 2009 6:58 AM
Answer Wiki:
That's all you should have to do. If you are adding in the group that you'll use for the sysadmins to get access, add the new one first then remove the old one.
To see all answers submitted to the Answer Wiki: View Answer History.
How about renaming the SQL Server group instead of adding and deleting, will the result be the same.
Example, if my computer has change it name from ABC to RRT, go to Computer Mangement, Local Groups, and rename all Window NT SQL Server group with reference to ABC to RRT, i.e. change SQLServer2005SQLAgentUser$ABC$MSSQLSERVER to SQLServer2005SQLAgentUser$RRT$MSSQLSERVER
Then go to Management Studio, go to Security, Logins then change all the SQL Server Group that are still referencing ABC to RRT, .i.e. change ABCSQLServer2005SQLAgentUser$ABC$MSSQLSERVER to RRTSQLServer2005SQLAgentUser$RRT$MSSQLSERVER, will this also be correct?
Sorry, should be….
ABCSQLServer2005SQLAgentUser$ABC$MSSQLSERVER to RRTSQLServer2005SQLAgentUser$RRT$MSSQLSERVER
The forward slash isn’t showing, ABC[forward_slash]SQLServer2005SQLAgentUser$ABC$MSSQLSERVER to RRT[forward_slash]SQLServer2005SQLAgentUser$RRT$MSSQLSERVER