How To: Change the Database Connection for Titan Server
How To: Change the Database Connection for Titan Server
Question
Can I change the database connection 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:
Pre-requisites
Titan Server installed on the system
Valid Titan Administrator credentials
Server Instance created with User Database Authentication method configured (e.g. SQLite) in which you would like to switch to another method of User Database Authentication (e.g. SQL Server)
Steps
Log into the Titan Administrator using valid credentials.
Navigate to the main homepage in the Admin UI (Domain/Server Information), and select “Add New” in the Server section.
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.
Ensure both Servers are Stopped.
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.
Click the … Actions menu to the right of the newly created Server. Choose to “Backup Server Config”.
Open the resulting .nxcfg file using Notepad or other file editor.
The DB Connection String is at the top of the document. Copy the value listed here.
Complete this same Backup process for the Primary Server.
- 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.
- 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.
Related to: Titan Server (2.x and later)
Related Articles
How-To: Changing SQL User Credential for Cornerstone MFT Server
Question How do I change the DB user credentials used for my Cornerstone MFT Server? Reasoning I recently migrated my Cornerstone MFT server from an older Operating System (OS) to a newer one. I also updated the user account used for the SQL ...How To: Create a Server With Windows Authentication In Titan
Question How do I create a server within Titan that utilizes Windows authentication? Reasoning I already have a database of users stored on a local windows server or an Active Directory server and would like to import these users into Titan and use ...How To: Use Hybrid Authentication In Titan
Related To Titan SFTP Server and Titan MFT Server. Question How can I use hybrid authentication in Titan? Reasoning I would like to be able to manage native user accounts and windows user accounts under one server instance to simplify administration. ...How To: Create SSH Keys and apply to a User
How To: Create SSH Keys and apply to a User Question How can I create SSH keys for users and use it as authentication aside from password? Reasoning SSH Key Authentication is more secure than Password authentication. Answer Follow the below ...KB PUSH and PULL in Titan MFT Server Next Gen
PUSH and PULL Automation Events in Titan MFT Server Next Gen Question How do I configure and use the PUSH and PULL capabilities in Events on my Titan MFT server? Pre-requisites: Titan MFT Server Next Gen must be installed on your server system ...