How To: Change the Database Connection for Titan Server

How To: Change the Database type for Titan Server

Question

Can I change the database type for my Titan Server? After setting up the server to use, for example, a local SQLite server, can I change the database connection to use, say, a pre-existing SQL Server in another location?

Answer

Yes, the database connection can be changed after being configured. It can be changed manually following the steps below:  Note: if you simply want to update existing database credentials or location select 'Edit Database Configuration' from the server action list in the Titan Administrator server list page.

Steps

1. Log into the Titan Administrator using valid credentials.

2. Navigate to the main homepage in the Admin UI (Domain/Server Information), and select “Add New” in the Server section.

1. Create a new Server Instance using the Titan Administrator. While setting up this new Server in Titan, choose the Database Connection type and configuration information you wish to use for the your pre-existing Server (e.g. pre-existing SQL Server in another location). Do not worry about protocol configuration or non-default configuration for anything except for the database connection to use.

2. Ensure both Servers are Stopped.

3. When finished successfully, you want to Export the server information for each of your servers so you can use the database connection string from the newly created Server to place the proper value into your Primary Server.

1. Click the … Actions menu to the right of the newly created Server. Choose to “Backup Server Config”.

1. Open the resulting .nxcfg file using Notepad or other file editor.

2. The DB Connection String is at the top of the document. Copy the value listed here.

1. Complete this same Backup process for the Primary Server.

2. Edit the .nxcfg file for the Primary Server and paste the DB Connection String value in to update the Primary Server. Save the file and close it.

Run an Import process. Browse and select the. nxcfg file you edited from your Primary Server. 

1. Choose to Update the existing Server Configuration from the list of options.

• Stop any Servers that may be running.

• Restart the Titan Server Service or Reboot the server system and then start the Primary Server Instance and use as desired.

• Once verified, you can Stop and Delete the ‘extra’ Server instance in the environment. Of course, DO NOT delete the now functional Primary Server that has the DB Connection you have properly changed.