Forum Discussion

PG's avatar
PG
Occasional Contributor
5 years ago
Solved

ReadyAPI 3.5.1 - DataSource Test Case - This driver is not configured for integrated authentication

Hello! I am using ReadyAPI 3.5.1. version Before this version I used Soapui Pro 5.1.1 version where the JDBC connection worked normally! At this program I have sqljdbcauth.dll and sqljdbc41.jar fi...
  • PG's avatar
    PG
    5 years ago

    Hello!

     

    I found the solution!

    I downloaded the sqljdbc_8.4.1.0_enu.zip from microsoft and copied the mssql-jdbc_auth-8.4.1.x64.dll file into 

    C:\Program Files\SmartBear\ReadyAPI-3.4.5\bin

     

    After that I restarted the ReadyApi, and the Datasource connect is working!

     

    Thank you!

     

    Regards,

    PG

richie's avatar
richie
Community Hero
5 years ago
Hey PG,

As far as i was aware the auth.dll handles windows auth and integrated, (integratedsecurity=true), so this issue is a bit of a weird one.

Id redownload both the latest jdbc driver .jar and the auth .dll. and stick them in bin/ext.

Also, are you sure youre using the correct .jar file relative to the sqlserver instance youre trying to connect to? I know sqljdbc42.jar is installed bybdefault with ReadyAPI! install, but when i connected to sqlserver 2016, i had to grab a newer version of driver.....cant remember the file name but it was quite long and definitely not sqljdbc42.jar.

I appreciate it works on SoapUI and youre thinking "shouldnt it work in ReadyAPI! too?" However, the differences between their codesets has been expanding for the last what....5? 6 years maybe? so i wouldnt be surprised if there are inconsistencies between them.

Ta

Rich
ChrisAdams's avatar
ChrisAdams
Super Contributor
5 years ago

Hi,

 

Once additional note to what richie wrote, when you copied the dll to folder, you need need to restart SoapUI ti pick up new dll files.