How to rename a server which already hosts an SQL server instance

Modified on 2020/06/17 08:16 by RSk Categorized as How to
==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.

[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}1.PNG|left|frameless|max800|Child Area]



[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}2.PNG|left|frameless|max400|Child Area]



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."

[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}3.PNG|left|frameless|max800|Child Area]


# Connect through the Object explorer to the other SQL istance present on the machine, hostname\FLSFRAMEWORK, as in the picture.

[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}4.PNG|left|frameless|max800|Child Area]




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

[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}5.PNG|left|frameless|max800|Child Area]



Open the tab "Database" and click on "Change Database"

[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}6.PNG|left|frameless|max800|Child Area]



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

[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}7.PNG|left|frameless|max800|Child Area]



Now open the scroll down menu and browse until "Report Server" is selected, then click "Next"

[image:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}8.PNG|left|frameless|max800|Child Area]



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:


[^https://docs.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-2017|Rename a Computer that Hosts a Stand-Alone Instance of SQL Server]

[file:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}Rename a Computer that Hosts a Stand.pdf|(Local copy)]


[^https://docs.microsoft.com/en-us/sql/reporting-services/report-server/rename-a-report-server-computer?view=sql-server-2017|Rename a Report Server Computer]

[file:{UP(How-to-rename-a-server-which-already-hosts-an-SQL-server-instance)}Rename a Report Server Computer.pdf|(Local copy)]
Meta Keywords:
Meta Description:
Change Comment:
FLSmidth QCX wiki

How to rename a server which already hosts an SQL server instance
