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: Add NT/SAM User in Titan
How To: Add NT/SAM User in Titan SFTP/MFT Server Question What are the detailed steps and best practices for adding an NT/SAM user in Titan MFT/SFTP, including any necessary configurations and settings to ensure proper integration with the LDAP ...How To: Create a Server With Windows Authentication In Titan
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 ...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: Limit Idle Connection Time of a User
How To: Limit Idle Connection Time of a User Question Is there a way to set a time limit for a user that we don't want connected for too long? Reasoning The Connections General tab is used to configure general connection settings. These values can be ...