How-To: Changing SQL User Credential for Titan
Question
How do I change the DB user credentials used for my Titan SFTP Server?
Reasoning
I recently migrated my Titan SFTP server from an older Operating System (OS) to a newer one. I also updated the user account used for the SQL connection for my Titan SFTP server in the ODBC Data Source applet, but I still get an error referencing the older SQL account
Answer
The DBUID and DBPWD for that Titan SFTP 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 Titan SFTP servers are encrypted so they need to be updated through the application to reflect the new credentials.
Steps
- From the Titan Admin web UI display the list of servers
- In the action menu for the server select 'Edit Database Configuration' to enter new DB credentials and click save