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?
May 11, 2009 7:18 AM
May 20, 2009 6:58 AM