Hello there,
I am trying to connect to an external database in another server by configuring a data source in our Appian environment (see image attached).
The problem is that I just find out we don't have installed yet the SQL Server JDBC Driver: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver.How do I install the driver on my server? I already have followed the instructions from this link: docs.appian.com/.../Configuring_Relational_Databases.html
But for some reason when I put manually the .jar file in the corresponding directory nothing happens. I still having the same error when configuring the data source in the admin console.
Any thoughts?
Discussion posts and replies are publicly visible
Hi jsalcedo28,
Follow the steps described in the following Installation Documentation
https://docs.appian.com/suite/help/20.2/Configuring_Relational_Databases.html#install-rdbms-driver
further, only the databases listed here are supported. Workarounds to access additional databases with other drivers are not supported.