I was trying to connect MS SQL server with mendix and it is showing ‘An error has occurred while handling the request. [User 'Anonymous_848f3767-1cb5-4253-a226-c3765b38ca89' with session id '65b969e9-XXXX-XXXX-XXXX-XXXXXXXX0b92' and roles 'Administrator']’ It is showing that in the port number database = ExternalDB is not valid. I understood maybe I am having problem with the constant ‘DB_URL’ that I have passed to the execute query element in the microflow. Default value- jdbc:sqlserver://LENOVO:database=ExternalDB; Have I written this right?
Try to give the URL with the Port number, the default port is 1433, you can check the below link on how to construct the JDBC URL with port number :