Procedure
Edit RSk: Instead of following the procedure below simply use the sqlfix.bat from ToolsNTv8 supplied on the Core release DVD or download "Installation Scripts for V8" on flsadev website.
-----------------------------
- Change the name of the server from the control panel as in this example.
Reboot the Server when asked to do so.
- Open Sql Server manager, log in to the main SQL istance corresponding to the machine hostname, select "New Query" and type in the following piece of code, where OLDNAME is the old name of the server, NEWNAME is the new one.
sp_dropserver OLDNAME;
GO
sp_addserver NEWNAME, local;
GO
Click on Execute and check that the Messages tab shows "Command(s) completed successfully."
- Connect through the Object explorer to the other SQL istance present on the machine, hostname\FLSFRAMEWORK, as in the picture.
Select "New Query" and type in the following piece of code, where OLDNAME is the old name of the server, NEWNAME is the new one.
sp_dropserver "OLDNAME\FLSFRAMEWORK";
GO
sp_addserver "NEWNAME\FLSFRAMEWORK", local;
GO
Click on Execute and check that the Messages tab shows "Command(s) completed successfully."
- Open the "Reporting Services Configuration Manager", from Start Menu -> Microsoft SQL Server 201x
Click on Connect as in the picture
Open the tab "Database" and click on "Change Database"
Type in the field "Server Name" the new hostname of the machine, NEWNAME in the previous examples. Click on "Test Connection" to verify and "Next" to go ahead
Now open the scroll down menu and browse until "Report Server" is selected, then click "Next"
Click "Next" on the following tabs, as the settings do not need to be changed. The last tab will take some time to execute the changes, finally you can click on "Finish"
- In case any FLS software is
already installed, it will be necessary to uninstall the Workplace from the Control Panel -> Programs and Feautures, and to regenerate the clickOnce application. Otherwise it will not be possible to install it from the browser.
In order to do that open the following path "C:\Program Files (x86)\FLSmidth\Core\8.x\Portal\UI\ClickOnceCreator" in a command prompt window, where x is the version of Core installed on the server.
From the command prompt run the executable "Fls.Core.Portal.UI.ClickOnceCreator.exe"
References
This tutorial has been written using the following references from Microsoft:
Rename a Computer that Hosts a Stand-Alone Instance of SQL Server(Local copy)
Rename a Report Server Computer(Local copy)