If during the testing of the SQL database connection an error popup will shown that the "adaptive Server connection failed" you have selected the wrong database type. Like you might have setup a MySQL server and selected MS SQL.
Change this and retest the connection.
[S1000][UnixODBC][FreeTDS][SQL Server] Unable to connect to data source
[S1000][UnixODBC][FreeTDS][SQL Server] Adaptive Server Connection Failed
If this article was not helpful and more help is needed please contact us via one of below options.
Our official support hours are 8:00 am to 16:30 pm, after those hours emailing us or submitting a ticket would be the best option.
When contacting our support team, please refer to the article you’ve checked and if possible add a picture of the error and add information on the hardware that’s giving the error. Make always sure you’re using the latest version.