April 16, 2018
Renaming a computer that hosts SQL Server

When changing the hostname of a computer running SQL Server, system metadata must be updated so that remote connections and applications do not lose connectivity. Those that use @@SERVERNAME or query SYS.SERVERS for the hostname that is. Microsoft's documentation pages are a must read as always. Some considerations include; failover clustering, mirroring, replication, SSRS, local authentication […]