Changing SQL Server name and SQL Server group name

290 pts.
Tags:
SQL Server group name
SQL Server 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.
ASKED: May 11, 2009  7:18 AM
UPDATED: May 20, 2009  6:58 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Db23
    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?
    290 pointsBadges:
    report
  • Db23
    Sorry, should be.... ABCSQLServer2005SQLAgentUser$ABC$MSSQLSERVER to RRTSQLServer2005SQLAgentUser$RRT$MSSQLSERVER
    290 pointsBadges:
    report
  • Db23
    The forward slash isn't showing, ABC[forward_slash]SQLServer2005SQLAgentUser$ABC$MSSQLSERVER to RRT[forward_slash]SQLServer2005SQLAgentUser$RRT$MSSQLSERVER
    290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following