We have configured EMR lab in our Alteryx server and it getting failed intermediately with below error. Due to which we are unable to connect the EMR lab through Alteryx server.
Error:
Connect In-DB (21) Error SQLDriverConnect: [Simba][Hardy] (34) Error from server: connect() failed: errno = 10061.[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
For resolving this issue, we need to restart the complete EMR server to bring back the connection live. Could you please assist us here to fix the connectivity issue permanently from Alteryx itself instead of restarting the server.