While attempting to access the resources inside the Tasktop Hub, getting an error the database is not available.
Issue Description: While attempting to access the resources inside the Task top hub and on utilizing an external database to store the operational data of Task top, the database is not available.
Resolution:
- Check if the configured database is available and accessible from the server where Task top hub is installed and hosted. If this is not accessible or able to reach from the server where the hub is hosted, then check with the Internal IT team who manages the database.
- If it is available, check if there are any changes that happened in the connection string or the username and password, then update the same accordingly from the settings tab of the Task top hub as mentioned here (General (Settings) - 23.2 (tasktop.com)).
- If unable to access the configuration under the settings tab, update the connection string or user details from tasktop-db.json file under ProgramData\Tasktop.
Example configuration under tasktop-db.json file
-------------------------------
{
"url": "jdbc:sqlserver://yourdatabase:1234/databasename",
"username": "yourusername",
"password": "yourpassword"
}
-------------------------------
- Once it connects successfully to the database, the password line is removed and saved securely.