dbTalk Databases Forums  

SQL Server logins Windows groups contain old hostname after EXECsp_addserver?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SQL Server logins Windows groups contain old hostname after EXECsp_addserver? in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
aj
 
Posts: n/a

Default SQL Server logins Windows groups contain old hostname after EXECsp_addserver? - 02-17-2010 , 03:34 PM






SQL Server 2005 SP2 9.0.3054

Using the
EXEC sp_dropserver '<old>'
GO
and
EXEC sp_addserver '<new>', 'local'
GO
commands, I have successfully changed the host name
of a SQL Server box.

However, I notice that afterwards, under SQL Server logins,
I have 3 Windows groups that still contain the OLD host name.

<OLDHOSTNAME>\SQLServer2005MSFTEUser$<OLDHOSTNAME> $MSSQLSERVER
<OLDHOSTNAME>\SQLServer2005MSSQLUser$<OLDHOSTNAME> $MSSQLSERVER
<OLDHOSTNAME>\SQLServer2005SQLAgentUser$<OLDHOSTNA ME>$MSSQLSERVER

Is it safe, using Mgmt Studio, to simply rename <OLDHOSTNAME> to
<NEWHOSTNAME> in these groups? Will I break anything?

TIA

aj

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.