Azure SQL DB connectivity

0
Hello Team,  In my Mendix app, I have a requirement to fetch data from external db that is 'Azure SQL db'. I am using Database connector to connect to Azure SQL db. I have seen so many success stories with Database connector to connect 'Azure SQL DB' although I have followed all the steps, I am getting error while connecting to my Azure SQL db. Can you please advise, If I am missing something.   Here is the screen shot of Execute Query dialog box:      Here are the error logs:  com.mendix.webui.WebUIException: Exception while executing runtime operation at com.mendix.webui.actions.client.RuntimeOperationAction.apply(RuntimeOperationAction.scala:72)   Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset ClientConnectionId:50f7970b-f256-48e5-bb7b-2508aebd338d at absence_management_portal.azure_db_test (JavaAction : 'Execute query')   Advanced stacktrace: at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:83)   Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset ClientConnectionId:50f7970b-f256-48e5-bb7b-2508aebd338d at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:108)   Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset ClientConnectionId:50f7970b-f256-48e5-bb7b-2508aebd338d at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23)   Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset ClientConnectionId:50f7970b-f256-48e5-bb7b-2508aebd338d at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:4266) at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2177) at com.microsoft.sqlserver.jdbc.SQLServerConnection.prelogin(SQLServerConnection.java:3976) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3788) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3348)
asked
0 answers