Forum Discussion

jkrolczy's avatar
Regular Contributor
12 months ago

SoapUI 5.7.0: What latest Microsoft JDBC Driver for SQL Server to use for DB connection And Auth ?


I would like to upgrade to the latest SoapUI 5.7.# … But I need to know from what I use below 

if there are newer files for JDBC DB connection And Auth.


I am currently using Open Source SoapUI 5.5.0 32-bit along with Microsoft JDBC Driver 6.0 for SQL Server
I am on a Win10 64-bit OS with java version 1.8.0_333


C:\Program Files (x86)\SmartBear\

I can currently do my needed SQL through my Groovy scripts and my REST request with Bearer authentication work fine as well.


I would like to upgrade to Open Source SoapUI 5.7.0 (which only 64-bit w/java seems to exists).


In doing so and I put my sqljdbc42.jar and sqljdbc_auth.dll (x64 version) in the same locations as SoapUI 5.5.0

everything does work correctly still except for this one line which I do not think is important ?


OpenJDK 64-Bit Server VM warning: Option --illegal-access is deprecated and will be removed in a future release.


If I move up in Microsoft JDBC Driver for SQL Server version:


example: 10.2 version files: mssql-jdbc-10.2.1.jre8.jar / mssql-jdbc_auth-10.2.1.x64.dll


Placement of these 10.2 version files in the folder locations like I did with sqljdbc42.jar and sqljdbc_auth.dll

does not allow SoapUI 5.7.0 to work as I expect to should.

Database connection cannot be established.


Is there a change on how to define the groovy script DB_connection = Sql.newInstance("jdbc:sqlserver .... ?

Should the files be placed in different folder locations?


Anyone setup OS SoapUI 5.7.0 in a manner I am trying - but that works for SQL through Groovy scripts ?



No RepliesBe the first to reply