One way to be sure is that open ur project in Eclipse and write a peice of code to connect to DB using tha same JDBC url.see if you are successful.
If it works here it will work in mendix too AFAIK.
I figured out the problem: I had to remove 'microsoft' from my jdbc string and it worked.
That is, the jdbc string used to be
' jdbcUrl=jdbc:microsoft:sqlserver://<server name>:<port>;databaseName=<database>',
then I changed it to
' jdbcUrl=jdbc:sqlserver://<server name>:<port>;databaseName=<database>'
and that fixed the problem.
Hi,
The database connector also already comes with a bunch of drivers included with the module, did you check the lib that you didnt put double drivers for the Microsoft JDBC?