Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

rename SQL server Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 12:48 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:17 PM
Points: 1,754, Visits: 3,161
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


  Post Attachments 
Capture.GIF (149 views, 4.39 KB)
Post #1426419
Posted Tuesday, March 5, 2013 7:39 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 5,976, Visits: 12,886
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.

---------------------------------------------------------------------

Post #1426832
Posted Tuesday, March 5, 2013 9:30 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:17 PM
Points: 1,754, Visits: 3,161
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
Post #1426895
Posted Tuesday, March 5, 2013 3:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 5,976, Visits: 12,886
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.

---------------------------------------------------------------------

Post #1427068
Posted Tuesday, March 5, 2013 5:04 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:17 PM
Points: 1,754, Visits: 3,161
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
Post #1427085
Posted Wednesday, March 6, 2013 6:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:42 AM
Points: 1,242, Visits: 2,743
We renamed a Win2003/SQL2005 server years ago. I left that the way it was and it has been fine for years.


Post #1427347
Posted Wednesday, March 6, 2013 9:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:17 PM
Points: 1,754, Visits: 3,161
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
Post #1427491
Posted Wednesday, March 6, 2013 9:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:42 AM
Points: 1,242, Visits: 2,743
That I don't know. Never tried it.


Post #1427493
Posted Wednesday, March 6, 2013 9:41 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 5,976, Visits: 12,886
why the frequent server renames, can they not be avoided?

---------------------------------------------------------------------

Post #1427502
Posted Wednesday, March 6, 2013 9:44 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:17 PM
Points: 1,754, Visits: 3,161
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,
Post #1427505
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse