December 1, 2010 at 3:09 pm
Thank you Chris, this is very helpful.
Thank you,sebastien piche for the listed instructions.
These all will help me do the migration as smooth as possible.
December 5, 2010 at 2:07 pm
Thank you, this is very helpful.
An additional question about this:
On the computer that hosts sql server, there are sql server related windows security groups created when installing sql server, example as :
SQLServer2005DTSUser$ComputerName
SQLServer2005MSFTEUser$ComputerName
SQLServer2005MSOLAPUser$ComputerName
SQLServer2005MSSQLServerADHelperUser$ComputerName
SQLServer2005MSSQLUser$ComputerName
SQLServer2005NotificationServicesUser$ComputerName
As you can see they have a string $computerName in it.
Also I see them in mangement studio-security-login too.
After renaming the computer, and run sp_dropserver, sp_addserver, is the computername changed in the security group name, or Do I have to manually change them to the new computer name?
Thank you!
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply