Locate the database connection config file and open it:
.wappler/targets/your_target/databases/conn_name.json
where “your_target” is your currently selected and the “conn_name” is your db connection name.
If you are opening it from Wappler file manager make sure to enable show hidden files first from the context menu so you can see the .wappler folder
In this json file you will see something like:
{
"direct": true,
"type": "mssql",
"connection": {
"host": "xxxxx",
"port": xxx,
"user": "xxxx",
"password": "xxxx",
"database": "xxxxx"
},
Add extra value “encrypt” : false, like:
{
"direct": true,
"type": "mssql",
"connection": {
"host": "xxxxx",
"port": xxx,
"user": "xxxx",
"password": "xxxx",
"database": "xxxxx",
"encrypt" : false
},
Let me know if this works.
Seems some MSSQL configurations does not have the right SSL options.
I based this on this issue: https://github.com/tediousjs/tedious/issues/914