Changing the hostname of the TVC server: Difference between revisions

From wiki.comcert.com
Jump to navigation Jump to search
VisualWikitext
(Created page with " == 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. &n...")
 
No edit summary
Line 11: Line 11:


=== To re-establish reporting on a renamed server: ===
=== To re-establish reporting on a renamed server: ===
===   ===


*
*
=== Note the former name of the server and rename the TVC server and restart the machine ===
Note the former name of the server and rename the TVC server and restart the machine


*
*
=== Stop the Visual Performance Manager Server and Visual UpTime Select Web Application services ===
Stop the Visual Performance Manager Server and Visual UpTime Select Web Application services


*
*
=== Open SQL Server Management Studio. Connect using the new server name and the "sa"account. ===
Open SQL Server Management Studio. Connect using the new server name and the "sa"account.


*
*
=== Use the aster database ===
Use the aster database


*
*
=== Execute the following query ===
Execute the following query


<pre>select @@servername</pre>
<pre>select @@servername</pre>


=== The former name of the server is shown ===
The former name of the server is shown


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


<pre>sp_dropserver '<old_name>'
<pre>sp_dropserver '<old_name>'
Line 42: Line 40:


*
*
=== Close SQL Server Management Studio and restart the SQL Server (MSSQLSERVER) service ===
Close SQL Server Management Studio and restart the SQL Server (MSSQLSERVER) service


*
*
=== Open SQL Server Management Studio and execute the following query ===
Open SQL Server Management Studio and execute the following query


<pre>select @@servername</pre>
<pre>select @@servername</pre>


=== The new name of the server is shown. ===
The new name of the server is shown.
 
=== To reconfigure the report server: ===
<div>
*Select&nbsp;Start&nbsp;>&nbsp;Run&nbsp;to open a command prompt and execute the following two commands.&nbsp;
*Substitute the proper login, if the default&nbsp;vuptime&nbsp;is not correct
<pre>cmd> rsconfig -e -m localhost -s localhost -d ReportServer -a Windows -u<NewMachineName>\vuptime -p<password>


=== To reconfigure the report server:<br/> Start the&nbsp;Reporting Services Configuration&nbsp;tool and connect to the report server that uses theReportServer database on the renamed server.Open the&nbsp;Database Setup&nbsp;page in the left panel.In&nbsp;Server Name, type or select the new SQL Server name and click&nbsp;Connect. (Use "SQL ServerAccount"credentials and enter the user name sa and its password in the&nbsp;SQL Server Connection&nbsp;dialog.)Click&nbsp;Apply. (Use SQL Server Account credentials and enter the user name sa and its passwordin thedialog.) Exit the panel.Run the VPM server prerequisite installation tool located on the VPM CD. From WindowsExplorer, navigateto the CD drive&nbsp;ServicePacks&nbsp;folder and open&nbsp;VisualPerformanceManager-Prerequisite.exe.This willreconfigure SQL Server Reporting Services for the server. ===
cmd> rsconfig -e -m localhost -s localhost -d ReportServerTempDB -a Windows -u<NewMachineName>\vuptime -p<password></pre>


*When the process is complete, reboot the server or restart the two services stopped earlier
*Check thatreports, including scheduled reports, execute properly
</div>
&nbsp;
&nbsp;


Revision as of 16:43, 19 February 2017

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.

To re-establish reporting on a renamed server:

Note the former name of the server and rename the TVC server and restart the machine

Stop the Visual Performance Manager Server and Visual UpTime Select Web Application services

Open SQL Server Management Studio. Connect using the new server name and the "sa"account.

Use the aster database

Execute the following query 

select @@servername

The former name of the server is shown

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

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

Close SQL Server Management Studio and restart the SQL Server (MSSQLSERVER) service

Open SQL Server Management Studio and execute the following query 

select @@servername

The new name of the server is shown.

To reconfigure the report server:

  • Select Start > Run to open a command prompt and execute the following two commands. 
  • Substitute the proper login, if the default vuptime is not correct
cmd> rsconfig -e -m localhost -s localhost -d ReportServer -a Windows -u<NewMachineName>\vuptime -p<password>

cmd> rsconfig -e -m localhost -s localhost -d ReportServerTempDB -a Windows -u<NewMachineName>\vuptime -p<password>
  • When the process is complete, reboot the server or restart the two services stopped earlier
  • Check thatreports, including scheduled reports, execute properly

 

  

 

 

Retrieved from "https://wiki.comcert.com/index.php?title=Changing_the_hostname_of_the_TVC_server&oldid=831"