ERR_SQL_DB_UNREACHABLE: Failed to reach database¶
DSS tried to connect to a SQL database but couldn’t establish the connection.
This error can happen:
when trying to create a new connection to a SQL database
when trying to read or write a SQL dataset
when trying to use a SQL notebook
This error indicates that the connection could not be established. The message of the error will contain additional information.
Some common reasons for failure to establish the connection are:
The connection settings (host, port, …) to the database are invalid
The database server is not running or not accepting connections
There is a firewall blocking connection attempts from DSS to the database server
Credentials entered in DSS for the database server are invalid
Remediation¶
Note
This issue can only be fixed by a DSS administrator
The first step for solving this issue is to go to the settings screen for the affected connection (Administration > Connections). You can test connection from here.
Refer to the documentation on SQL databases in order to get additional information on the support of your specific database by DSS.
Make sure that the connection settings are correct
If you get “connection refused” or similar errors, check that the database server is properly running
Check if a firewall is blocking connections between DSS and the database server (this can result in either “connection refused” issues, or timeout issues)