Rinominare un server che esegue Sql Server

  • Article

Ho raccolto in questo post i documenti utili nel caso sia necessario rinominare un server standalone che esegue Sql Server o un Virtual Server in caso di configurazioni in Failover Cluster.

NOTA : Sql Server 2000 non supporta questa operazione per i virtual server clustered.

Sql Server 2008 standalone

https://msdn.microsoft.com/en-us/library/ms143799.aspx

Considerazioni :

  • SQL Server does not support renaming computers that are involved in replication, except when you use log shipping with replication. The secondary computer in log shipping can be renamed if the primary computer is permanently lost. For more information, see Replication and Log Shipping.
  • When you rename a computer that is configured to use Reporting Services, Reporting Services might not be available after the computer name change. For more information, see Renaming a Report Server Computer.
  • When you rename a computer that is configured to use database mirroring, you must turn off database mirroring before the renaming operation. Then, re-establish database mirroring with the new computer name. Metadata for database mirroring will not be updated automatically to reflect the new computer name. Use the following steps to update system metadata.
  • Users who connect to SQL Server through a Windows group that uses a hard-coded reference to the computer name might not be able to connect to SQL Server. This can occur after the rename if the Windows group specifies the old computer name. To ensure that such Windows groups have SQL Server connectivity following the renaming operation, update the Windows group to specify the new computer name.

Sql Server 2008 cluster

https://msdn.microsoft.com/en-us/library/ms178083.aspx

Considerazioni :

  • SQL Server does not support renaming servers involved in replication, except in the case of using log shipping with replication. The secondary server in log shipping can be renamed if the primary server is permanently lost. For more information, see Replication and Log Shipping.
  • When renaming a virtual server that is configured to use database mirroring, you must turn off database mirroring before the renaming operation, and then re-establish database mirroring with the new virtual server name. Metadata for database mirroring will not be updated automatically to reflect the new virtual server name.

Sql Server 2005 standalone

https://msdn.microsoft.com/en-us/library/ms143799(SQL.90).aspx

Sql Server 2005 cluster

https://msdn.microsoft.com/en-us/library/ms178083(SQL.90).aspx

Sql Server 2000 standalone

https://msdn.microsoft.com/en-us/library/aa197071(SQL.80).aspx

Sql Server 2000 cluster

https://support.microsoft.com/kb/307336/en-us

renaming the SQL Server virtual, or clustered, servers is not supported in the current version of Microsoft SQL Server. If you rename the SQL Server Network Name resource, a variety of problems may occur