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 ...2019: Titan FTP Server Release Notes
Important Information Titan FTP Server must be installed under an account that has full administrative rights to the computer on which the software is being installed. To uninstall Titan FTP Server, use the Add/Remove Programs feature of the Windows ...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 Nextgen
Related To Titan Nextgen Enterprise Plus Builds 2.x and above. Question How can I use hybrid authentication in Titan Nextgen? Reasoning I would like to be able to manage native user accounts and windows user accounts under one server instance to ...How To: Create a server with Windows LDAP authentication in Titan Nextgen
Related To Titan Nextgen Builds 1.x and above. Question How can I configure a server to utilize LDAP as the authentication server in Titan Nextgen? Reasoning I would like to be able to integrate my current database of users so I can give them access ...