Connecting to an external database with integrated security
0
I am trying to connect my Mendix application to an extrnal DB. I have seen two approaches: 1. Use the extrnal database instead of the in-build one, by adding it through configuration in project settings 2. Use the External Database Connector module, which then doesn't use the DB directly instead of the Mendix one, but I can execute queries there from my Mendix app I have managed to get the first case working using a jdbc connection string. The second case, however, I can not do. My local database server is using Integrated Security, which does not seem to be supported by the module. The module requires I input the login credentials, and it does not work even if I insert the jdbc string with IntegratedSecurity set to true and use dummy values in the login. Is the module just not usable with integrated security at all, or am I missing something?
asked
Vojtěch Šiler
1 answers
0
Can you try following steps and check?
1. Download Microsoft SQL Server JDBC driver version 12.6.3.jre11 (from here).
2. Replace the existing `mssql-jdbc` JAR in the `userlib` directory with the newly downloaded.
Then use connection string with IntegratedSecurity=true and dummy values for the credential.