Issue
There is a requirement to change the WebReport server name.
Product Line
EcoStruxure Building Operation
Environment
- Building Operation Report Server
- Building Operation WebReports
- SQL Server
Cause
Changing the WebReports server name after the WebReports software has been installed, does not change the PC name references in the WebReports or the database.
Resolution
If possible, ensure that the PC name will not need to be changed after the PC has been configured for WebReports.
If having configured a PC for WebReports, the PC name has to be changed, then backup all SQL data first then uninstall the WebReports software, ensuring that the following process is followed step by step.
Below is an overview of the uninstall process, the exact details are shown in section 15.11 of the WebReports Reference Guide.
15.11 Uninstalling WebReports
Complete the following tasks to uninstall WebReports and the WebReports database:
- Uninstall the WebReports application and services using Windows Control Panel
- Delete the WebReports database using Microsoft SQL Server Management Studio
- Delete the WebReports reports using SQL Server Reporting Services Report Manager
- Remove the virtual directories for WebReports and the WebReports service using Internet Information Services (IIS) Manager
- Remove the WebReports application pools using the Internet Information Services (IIS) Manager
- Delete the appuser and IUSR accounts (if they exist) using SQL Server Reporting Services Report Manager, Microsoft SQL Server Management Studio, and Windows Computer Manager.
Please note that having uninstalled the WebReports software, follow the steps shown on the following Microsoft website: Rename a computer that hosts a stand-alone instance of SQL Server - SQL Server
If this procedure fails then SQL Server should also be reinstalled after having changed the PC name first.