Changing the hostname of the TVC server

Introduction

By no means should you attempt to change the hostname of the TVC sever on a TruView all-in-one appliance (TVA) or join this server to a Windows domain.  This is unsupported and voids the maintenance agreement.

Renaming a TVC server affects the communication between SQL Reporting Services and the server. Therefore, before renaming a server, first verify that scheduled and unscheduled reports are successfullyrunning on the server.Once you have renamed a TVC server, take the following steps to make sure that reports will run on the server.

Solution

You must know the sa user password for SQL server and the Windows vuptime user password.

Execute the following query

select @@servername

Execute the following query to update @@servername. Replace <old_name> and <new_name>

sp_dropserver '<old_name>'
GO
sp_addserver '<new_name>', local
GO

Open SQL Server Management Studio and execute the following query

select @@servername