How-To: Changing SQL User Credential for Cornerstone MFT Server

How-To: Changing SQL User Credential for Cornerstone MFT Server


How do I change the DB user credentials used for my Cornerstone MFT Server?


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 connection for my Cornerstone MFT server in the ODBC Data Source applet, but I still get an error referencing the older SQL account


The DBUID and DBPWD for that Cornerstone MFT Server needs to be updated to reflect the new user credentials. This update needs to be reflected in the ODBC Data Source applet and in the registry.  The DBUID and DBPWD in the registry for Cornerstone MFT servers are encrypted so they need to be updated through the application to reflect the new credentials.

Pre-requisites (if reinstalling Cornerstone MFT)

  1. Make a backup of the following registry keys (Run, Regedit):
  2. South River Technologies registryHKEY_LOCAL_MACHINE\SOFTWARE\South River Technologies


  1. Create a new dummy server inside of Cornerstone using the new username and password when prompted for the SQL database name, userid and password
  2. Once the server has been created inside of Cornerstone, stop the Cornerstone MFT service and close the Admin console
  3. Navigate to the registry, locate the new server key under Servers (it is numerical, so the next ServerID should be 3) and confirm it has 5 items in it: Default, ClusterIdDatabaseDSN, DBPWD and DBUID
  4. Export registry keys 2 and 3 from the registry, open both using Notepad and update the DBUID and DBPWD in key 2 to reflect the values of DBUID and DBPWD of key 3
  5. Save the changes for key 2 and merge it to the registry by executing it
  6. Start the Cornerstone service and log into the Cornerstone Admin console
  7. Confirm you do not receive the error upon logging in and navigating the server
  8. If all is okay, delete the dummy server created in step 1
    • Related Articles

    • 2019: Cornerstone MFT Server Release Notes

      Important Information Cornerstone MFT Server must be installed under an account that has full administrative rights to the computer on which the software is being installed.  To uninstall Cornerstone MFT Server, use the Add/Remove Programs feature of ...
    • NX: Cornerstone MFT Server system requirements

      The following lists the minimum system requirements for running Cornerstone MFT Server - NextGen Edition Supported Operating Systems Windows Server 2016 or later, all 64-bit editions (32-bit is not supported) Windows 10 Professional TH1 1507 or ...
    • How To - Upgrade From Legacy Cornerstone MFT To NextGen Titan MFT

      How To: Upgrade From Legacy Cornerstone MFT To NextGen Titan MFT Question How can I upgrade from legacy Cornerstone MFT 2019 to Cornerstone MFT NextGen? Reasoning With the release of the Cornerstone MFT NextGen version, we would like to take ...
    • 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 ...
    • Titan MFT Server End User License Agreement (EULA)

      The current EULA for Titan MFT (aka Cornerstone MFT Server) is located on our website