SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


rename SQL server


rename SQL server

Author
Message
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10125 Visits: 4195
After we changed computer name, and I renamed SQL server name too following ms articles. by using sp_dropserver, sp_addserver.

But I see there are still somewhere on the server left with old computer name footprint.

For example: there are some windows group see attached, they have old computer name there, shall I rename the groups?
I am afraid if I rename it to include newer computer names, it will break something in the server, or registry?

Or it is safe to rename?


Thanks
Attachments
Capture.GIF (174 views, 4.00 KB)
george sibbald
george sibbald
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24080 Visits: 13698
The SID for the groups is actually used and this is not changed by the server rename so you don't have to rename the groups.

---------------------------------------------------------------------
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10125 Visits: 4195
george sibbald (3/5/2013)
The SID for the groups is actually used and this is not changed by the server rename so you don't have to rename the groups.


Thanks, that is good to know.

But if I change it, will it affect anything, do those group name exist somewhere on the server, like registry etc. I checked they are not in security- login.

Because we often have the situations like this - to rename servers, and leave the old computer names in windows group look unclean and confusing.

But I wonder if I change them by replace the string of old computer name with new computer name in the windows group name, will it affect anything?


Thanks
george sibbald
george sibbald
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24080 Visits: 13698
these groups are used to manage security outside of SQL, so I cannot see a reason they cannot be renamed like any other windows group, but I have never tried it so would not like to definitely say yea or nay.

---------------------------------------------------------------------
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10125 Visits: 4195
george sibbald (3/5/2013)
these groups are used to manage security outside of SQL, so I cannot see a reason they cannot be renamed like any other windows group, but I have never tried it so would not like to definitely say yea or nay.


Thank you, understandable.

I can leave as they are, but since we do server renaming quite often whenever we do some upgrade, so would like to keep servers clean.

But I got most of answers for this question is they are optional, and it seems most DBA leave them as they are, but I can never find somewhere online in microsoft site said if it is OK to change them and it won't affect anything.


Thanks
Summer90
Summer90
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 7005 Visits: 3831
We renamed a Win2003/SQL2005 server years ago. I left that the way it was and it has been fine for years.
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10125 Visits: 4195
Markus (3/6/2013)
We renamed a Win2003/SQL2005 server years ago. I left that the way it was and it has been fine for years.


Thanks, I think to leave them as the old computer name in the windows group, it should be fine.
But I would like to know to change the windows group to inlcude new server name, will that affect anything?

Thanks
Summer90
Summer90
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 7005 Visits: 3831
That I don't know. Never tried it.
george sibbald
george sibbald
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24080 Visits: 13698
why the frequent server renames, can they not be avoided?

---------------------------------------------------------------------
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10125 Visits: 4195
As a DBA, I often have to rename server name when do the migration to a new server, or to do a Virtual to virtual clone.

By renaming server name, save work for the application developer to have to change their connection strings in code or anything other places.

So as time goes, I have to do the renaming servers thing more and more.

That's why try to figure out how to keep clean the server by changing windows group name reflecting new server name.

Thanks,
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search