Prev: ODBC Connection Wizard: Can't see SQL Server
Next: C API
From: aj on 17 Feb 2010 15:34
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$<OLDHOSTNAME>$MSSQLSERVER

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

TIA

aj
 | 
Pages: 1
Prev: ODBC Connection Wizard: Can't see SQL Server
Next: C API