How To: Change the Database Connection for Titan Server

How To: Change the Database Connection for Titan Server

How To: Change the Database Connection for Titan Server


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?


Yes, the database connection can be changed after being configured. It can be changed manually following the steps below:


  1. Titan Server installed on the system

  2. Valid Titan Administrator credentials

  3. 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)


  1. Log into the Titan Administrator using valid credentials.

  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 ServerChoose 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.
  3. Run an Import process. Browse and select thenxcfg file you edited from your Primary Server. 

A screenshot of a computerDescription automatically generated

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

A screenshot of a computer errorDescription automatically generated

  1. Stop any Servers that may be running.
  2. Restart the Titan Server Service or Reboot the server system and then start the Primary Server Instance and use as desired.
  3. 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 ...