Created an API using sql server. I observed test connection to SQL server is intermittent, for some attempts test connection is successful but frequently it gives error as shown in attachment. Please advise.
Do you see any errors in the web server logs? (i.e: catalina for tomcat).
I've seen these types of errors with network instability (inconsistent connections to the DB server).
Could you also confirm the version of LAC, MS SQL & JDBC driver you are running?
Retrieving data ...