May 23, 2012 at 10:02 am
I see there are two some windows group, it was created when SQL server was installed.
The windows group name are like SQLServerSQLAgentUser$MyComputerName$MSSQLSERVER, SQLServerMSSQLUser$MycomputerName$MSSQLSERVER etc,all these names have the server name in the group name.
My question is when we migrate or upgrade server and move to a new server, we usually need to rename server name. We know we need to change physical computer name, and also use sp_dropserver, and sp_addserver. But after renaming server, some footprint of old server name still exist in windows, like the ones above.
Do we need to change the name, or leave as they are, if changed, will it affect SQL server?
I search in all microsoft site, cannot find an answer for this.
May 23, 2012 at 11:24 am
The name of the group has no relation to the server name. You can change it if you like, for clarity, but it doesn't matter.
May 23, 2012 at 11:47 am
Thanks!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply