We’ve updated Microsoft JDBC drivers for SQL Server that are bundled with ReadyAPI
I Installed ReadyApi 3.9.2 and none of my jdbc connections will work on various projects. The common Complaint is:
Failed to get a connection for the specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:a4128829-7b7c-4a14-b93a-0404c13e0064
I always copy over the existing sqljdbc_auth.dll to my existing ...SmartBear\ReadyAPI-3.9.2\bin folder during new version installs.
I even downloaded the current new ms \sqljdbc_9.4\enu\auth\x64\mssql-jdbc_auth-9.4.0.x64.dll and have copied that to the ...SmartBear\ReadyAPI-3.9.2\bin folder, then restarted ReadyApi and I still get the Failed to get a connection message on multiple existing jdbc connections.
I have tried renaming the file, I have tried using the old auth.dll file, I have tried using the new 9.4.0 auth.dll file and nothing is working.
Connection strings generally look like:
Does anyone know how to get integrated Security to work with the new drivers?
I am just now finding some different possible values to use for auth per the MS info at: https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15
I will try the ActiveDirectoryIntegrated value.
(Version 6.0+) This optional property indicates which authentication method to use for connection. Possible values are ActiveDirectoryIntegrated, ActiveDirectoryPassword, ActiveDirectoryMSI (version 7.2+), ActiveDirectoryInteractive (version 9.2+), ActiveDirectoryServicePrincipal (version 9.2+), SqlPassword, and the default NotSpecified.
While trying a few things, I noticed the ms sql jar file (mssql-jdbc-9.2.1.jre15.jar) that comes with ReadyApi is version 9.2 - which was released in January 2021, and is NOT the Latest file available from MS. C:\Program Files\SmartBear\ReadyAPI-3.9.2\bin\ext\mssql-jdbc-9.2.1.jre15.jar
So I went to get the 9.2 version of jdbc drivers to use that auth.dll file (mssql-jdbc_auth-9.2.1.x64.dll). IT WORKS!
Anyone who may run into this issue - you can find the MS jdbc driver file here: https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#92
Long story short the readyapi Release notes are bit inaccurate. At this link: https://support.smartbear.com/readyapi/docs/general-info/version-history/features-added-to-ver-3-9-2.html It says:
We’ve updated Microsoft JDBC drivers for SQL Server that are bundled with ReadyAPI. New driver version includes new features and bug fixes. The full list of changes you can find on the Microsoft’s web site.
That link takes you to the 9.4 Version which that Auth.dll file is throwing the Complaints about - This driver is not configured for integrated authentication.