8.7 Upgrade : This driver is not configured for integrated authentication.

0
We have upgraded a working solution from version 8.6 to 8.7. Since upgrading, we recieve the following exception on startup : "Opening JDBC connection to Some(sqlserver\SQL) failed with SQLState: 08S01 Error code: 0 Message: This driver is not configured for integrated authentication." We also noted that version 8.7 has a new JDBC driver.   We attempted to add the correct JDBC driver in the userlib folder, but still the error remains.   What other options do we have here? 
asked
2 answers
2

Never mind, we managed to fix it this morning.

The fix entailed copying mssql-jdbc-7.4.1.jre11.jar to Mendix Studio Pro 8.7.0 install directory’s \runtime\bundles directory (In our case it is “C:\Program Files\Mendix\8.7.0.1476\runtime\bundles\”)

This in essence “overrides” the reference to com.microsoft.sqlserver.mssql-jdbc.8.2.0.jre11.jar, which ships with the 8.7 upgrade (Mendix 8.6 shipped with com.microsoft.sqlserver.mssql-jdbc.7.2.1.jre8.jar).

answered
2

Regarding Andrej’s comment on the answer (and for completeness sake) :

 

When deploying to a server environment, the same “fix” applies, but the directory where the mssql-jdbc file needs to go is in the Mendix Server distribution install location under ...\Servers\server version\runtime\bundles\

 

 

answered