Changing the server name of a BMD NTCS installation (including SQL instance)

This guide is for skilled IT administrators with experience in working with BMD NTCS . It covers the following scenario:

You want to change the name of your BMD NTCS server and the SQL Server installation is located on this server. Please note that you should do a backup before any changes are made to the server.

For the procedure described below, all users have to be logged out of BMD NTCS.

1. Preparations

Please consider before proceeding with the first steps:

Expect downtime
- Due to the adjustments made, you have to plan for some downtime. Depending on resources and performance of your server, downtime can take up to several hours.
Database backup is optional (for instructions on backing up your database please refer to www.bmd.com/en – Technical documentation)
Are other databases active on the server?
- BMD cannot be held responsible for the functionality of these databases!
New server name

2. Uninstalling BMDNetClient

At first, you should uninstall the BMD NTCS client from every workplace, since later on the network path is going to change according to your adjustments. This step has to take place before renaming the server.

Use BMDNTCS_PGM share to start BMDNetClient.exe.

Start BMDNetClient.exe by right-clicking and selecting ‘Run as administrator’.
Alternatively, you can run BMDNetClient.exe after starting BMDNetClient under Tools and ‘Restart as administrator’.

Then click on File → Uninstall NetClient. If you use Office add-ins, you have to close all Office applications before uninstalling.

After successful deinstallation you can continue with the next step.

3. Deleting maintenance plans

BMD recommends deleting all maintenance plans before renaming the computer. If this is not done, you might no longer be able to properly delete or start the maintenance plan.

Start SQL MGMT Studio, expand ‘Maintenance Plans’ and click on the respective maintenance plan.
By right-click and ‘Delete’ you can delete the respective plan.
The new maintenance plan will be set up later, after renaming the server.

4. Changing computer names

Adjust the settings of the computer name (Control panel - System) accordingly.

In our example we use the new name “BMDNTCSneu”.
To apply the new name it is necessary to restart the computer.

5. Adjusting configuration files

First, you have to adjust the respective INI files used by BMD NTCS.

5.1. BMD.ini

You can find BMD.ini in the BMD NTCS installation directory. This directory is located on the respective drive (e. g. C:\ or D:\ – Program Files (x86) – BMDSoftware)

Change all server name entries to the new server name.
To make sure that you do not miss any entries, you can use the ‘Search and Replace’ function of the editor (notepad). (Edit –> Replace)
Enter the old server name.
Enter the new server name underneath.
Click on ‘Replace all’.
Then save the file.

5.2. BMDGLOBAL.ini

BMDGLOBAL.ini is in the same directory as BMD.ini.

Again you have the option to use ‘Search and replace’ to rename the entries as described above.
Save the file after changing the names.

5.3. BMDClient.ini

You can find BMDClient.ini in the folder ProgramData (hidden).

C:\ProgramData\BMDNTCS\BMDClient.ini

Here you can again use ‘Search and replace’ to rename the entries as described above.
Save the file after changing the names.

5.4. BMDSOAPService.ini

Cab be found in the installation directory of BMD NTCS.

Here you can again use ‘Search and replace’ to rename the entries as described above.
Save the file after changing the names.

5.5. BMDSYNCService.ini

If Exchange synchronization is enabled, you have to adjust BMDSYNCService.ini accordingly.

Again, you have the option to use ‘Search and replace’ to rename the entries as described above.
Save the file after changing the names.

6. Changing the paths in the database

Next you have to adjust the paths of BMD NTCS, since they still refer to the old server name.

Start BMDDBUpdate.exe in the BMD NTCS installation directory.
Make sure to select the correct instance name as your database.
Specify BMD as the user in the login window and do not enter a password, since Windows login will be used. Then click on ‘Login’.
Note: This is also where you select the database.

If you get a notification that there is an available update, you can skip it. Next, the following window opens:

Select the option ‘Change server name and net path’ under Extra → Various search routines → Change server name and net path.

In this menu you can now check how many entries there are under the current path name by entering \\ and tab. This gives you an overview (preview) of the current paths with the old server name. The number of paths can vary.

The next step is to enter the old server name in the window ‘Derzeitiger Pfadname’ (current path name) and the new server name in the window ‘Neuer Pfadname’ (new path name). Click on ‘OK’. Please double-check the spelling of the new server name.

Then click on ‘OK’.
After doing this, you can check again whether the paths have been set correctly.
Just enter the new server name in the field ‘Current path name’ to view the preview of the entries with the new name.
Then close the DBUpdate window by clicking ‘Close’.

7. Login SQL MGMT Studio

When logging in to SQL Server Management Studio you now need to use the new server name to establish a connection.

7.1. Registering the new computer name in the SQL Server

If you rename a server, on which an SQL instance is installed, you have to enter the following command in the Query Editor of MGMT Studio in order to allow for correct registration of the new computer name.
Please note that after registering the new server name you have to restart the SQL Server to apply the changes!

Right-click on BMD database -> New Query

Now enter the following command to delete the old server name (please add the respective server name) and then click on ‘Execute’:

sp_dropserver ‚oldservername\bmd‘
GO

If you set the command correctly, it will be displayed as “completed successfully” in ‘Messages’:

Next, enter the following command to register the new server name and add the respective server name (in this example it is ‘BMDNTCSNEU’):

sp_addserver ‘newname\bmd', local
GO

Then restart SQL Server (Restart service).
Use the following command to check whether the process was successful:
SELECT @@SERVERNAME AS 'Server Name' (replace “Server Name” with your new server name)

The results should no longer include entries of the old server name.

7.2. Setting up a BMD maintenance plan

If you deleted the maintenance plan, you now have to set it up again. For this, please refer to our online documentation „Creating an SQL maintenance plan“.

8. Starting services

Since the SQL and BMD NTCS services might have been stopped, you have to start them manually. You can do this via ‘Services/Services on the server’. Check whether the services are already running. In general, SQL Server services are started automatically when you restart the server.

9. Starting BMD NTCS

Log in with your user details and then start BMD NTCS with your user name. If single login is active, you can start BMD NTCS without entering the user name.

10. Checking single login (optional)

Due to changing the server name, you now have to check the single login details in BMD NTCS (if you are using single login).

Go to the user administration window in BMD NTCS under Tools → Administration → Authorization → Users. Under ‘Functions’ you can select the option ‘Check single login file’.

Now test on your workplace (client) if single login (automatic login to BMD NTCS) works for the user with enabled single login.

11. Installing BMDNetClient

In this step we reinstall BMDNetClient at the desired workplaces. Install the Client as per usual via the PGM share of the server. In our case we can share by using \\BMDNTCSNEU (enter this link f. i. in the address field of Windows Explorer) → bmdntcs_pgm → BMDNetclient.exe.

Now start the setup and install BMDNetClient. After installing BMDNetClient you can start BMD NTCS via desktop link.

12. Checking if you can start BMD NTCS on all systems

The next step is to check if you can start BMD NTCS on all systems (servers and clients) as before.

13. Troubleshooting:

13.1. BMDClient login window does not display any information

If the login window of BMDNetClient does not display any information, these are the possible causes:

In case that the NetClient that still refers to the old server name is installed on the computer and has not been uninstalled properly before starting BMD NTCS, a white or incomplete user interface may appear.

If this is the case, you have to start client installation via share on the new BMD NTCS server.

Then check in the top section of the next window whether the new server name is listed. This is to ensure that BMDNetClient.exe has been started via the correct share.

In the lower section of the window you can check if you need additional options like ‘Local archive-add-ons’, etc. (You also have the option to add these later by running client installation again.)

Now start installation by clicking on the button ‘Install’.
Please note that installing the client can take a few minutes.

After successful installation you will get a notification. You can then close the installation window of BMDNetClient.

You can delete any remaining desktop links to the old BMD NTCS server. In our example the new desktop link looks like this:

13.2. Database error / SQL

If you did not make the adjustments as described above, you will get a notification after restarting the server and starting BMD NTCS (including login).