Anyone came across the below error while connectin...
# cfml-general
v
Anyone came across the below error while connecting the Azure Database instance with Active Directory user Coldfusion 2016 - Update 17
Copy code
com.microsoft.sqlserver.jdbc.SQLServerException: Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication.
The root cause was that: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication.
z
I know the answer, but you can google MSAL4J first and let us know if you can figure it out
v
I tried I am not sure where to get the latest jar file and which will support Coldfusion 2016.
z
not sure if the version needs to match the jdbc client version
v
I will try with the latest version
@zackster: After copying the jar file to the lib folder I got a different "time out" error However when I connect with sa account (non AD ) it works. Also able to connect the DB through SSMS with the same AD user (same CF server) --------------------------------------------------------- Do we need to execute the jar file or something else I am missing here to make the AD account work
z
did you restart?
v
Copy code
java.sql.SQLException: No suitable driver available for <<Datasource>>, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDrive