Changing the hostname of the TVC server: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
== Introduction == | == 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 | {{#invoke:Message box|ambox |type=speedy|text=By no means should you attempt to change the hostname of the TVC sever on a TruView all-in-one appliance (TVA) or join that server to a Windows domain. This is not supported 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. | 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. | ||
| Line 8: | Line 8: | ||
== Solution == | == Solution == | ||
You must know the sa user password for SQL server and the Windows vuptime user password. | You must know the "sa" user password for SQL server and the Windows "vuptime" user password. | ||
=== 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 MS SQL Server Management Studio. Connect using the new server name and the "sa"account. | *Open MS SQL Server Management Studio. Connect using the new server name and the "sa" account. | ||
*Use the master database | *Use the master 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>' | ||
GO | GO | ||
| Line 29: | Line 29: | ||
GO</pre> | GO</pre> | ||
* | *Close SQL Server Management Studio and restart the SQL Server (MSSQLSERVER) service | ||
*Open SQL Server Management Studio and execute the following query | |||
Close SQL Server Management Studio and restart the SQL Server (MSSQLSERVER) service | |||
* | |||
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 | | ||
=== To reconfigure the report server === | |||
<div> | <div> | ||
*Select Start > Run to open a command prompt and execute the following two commands | *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 | *Substitute the proper login, if the default vuptime is not correct | ||
<pre>cmd> rsconfig -e -m localhost -s localhost -d ReportServer -a Windows -u<NewMachineName>\vuptime -p<password> | <pre>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></pre> | |||
| |||
=== Run the prerequisite tool === | |||
Run the VPM server prerequisite installation tool located on the DVD. When the installation or upgrade of the TVC has been done by our service team, the DVD can be found in the Staging folder on either the D:, E: or F: drive on the TVC server. From Windows Explorer, navigate to the ServicePacks folder and open VisualPerformanceManager-Prerequisite.exe. | |||
This DVD can be found in the folder \Staging in either D:, E: or F: drive on the TVC server. | |||
| |||
=== Verify your work === | |||
*When the process is complete, reboot the server or restart the two services stopped earlier | *When the process is complete, reboot the server or restart the two services stopped earlier | ||
Latest revision as of 07:26, 20 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 that server to a Windows domain. This is not supported 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 MS SQL Server Management Studio. Connect using the new server name and the "sa" account.
- Use the master 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>
Run the prerequisite tool
Run the VPM server prerequisite installation tool located on the DVD. When the installation or upgrade of the TVC has been done by our service team, the DVD can be found in the Staging folder on either the D:, E: or F: drive on the TVC server. From Windows Explorer, navigate to the ServicePacks folder and open VisualPerformanceManager-Prerequisite.exe.
This DVD can be found in the folder \Staging in either D:, E: or F: drive on the TVC server.
Verify your work
- When the process is complete, reboot the server or restart the two services stopped earlier
- Check thatreports, including scheduled reports, execute properly