I’ve been trying to set up a database connection for MSSQL database which is running on an MSSQL 2019 server and end up having faulted connection. I checked the URL, db name, and the user credentials it looks right. I’ve tried logging in with the same credentials on the server management studio and it works.
Is the JDBC driver that comes in as default compatible with the 2019 server version or is it only for 2016 version? Or do I need some special switch to make it work?