June 9, 2009 at 10:25 am
I installed SQL Server 2005 on a virtual server that is being used as a template for building new servers. When I created it, I had to set it up to run under the local account but when a new server is created, there are many steps I go through to change the service to a domain account as well as various other changes. One of the changes I make is to change the server name using the following:
EXEC sp_dropserver 'Old_Server_Name'
GO
EXEC sp_addserver 'New_Server_Name', 'local'
GO
My problem is the local server groups created by SQL Server, such as:
Old_Server_Name\SQLServer2005MSFTEUser$Old_Server_Name$MSSQLSERVER
Old_Server_Name\SQLServer2005MSSQLUser$Old_Server_Name$MSSQLSERVER
Old_Server_Name\SQLServer2005SQLAgentUser$Old_Server_Name$MSSQLSERVER
I cannot get these groups to reflect the name change. I would like to get them changed to:
New_Server_Name\SQLServer2005MSFTEUser$New_Server_Name$MSSQLSERVER
New_Server_Name\SQLServer2005MSSQLUser$New_Server_Name$MSSQLSERVER
New_Server_Name\SQLServer2005SQLAgentUser$New_Server_Name$MSSQLSERVER
I have looked around and several people seem to have this problem but I haven't found a solution.
Thanks.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
June 9, 2009 at 1:20 pm
I have seen this issue somewhere on SSC forums but I cannot come across the posting.
I believe the resolution was you can just rename the group in Computer Management of the server. Then you will go into SSMS and drop the current groups and add the groups you just renamed.
I can't remember if there was anything other than that.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply