Forum Discussion

PG's avatar
PG
Occasional Contributor
4 years ago

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
    4 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
4 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
    Champion Level 3
    4 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.

    • PG's avatar
      PG
      Occasional Contributor
      4 years ago

      Hello

       

      I downloaded a sqljdbc_8.4.1.0_enu.zip from microsoft page, and i copied the mssql-jdbc_auth-8.4.1.x64.dll and the mssql-jdbc-8.4.1.jre8 JAR file in the bin\ext folder, after that i restart ReadyApi but the problem is still living.

       

      Maybe I downloaded wrong package?

       

      My Java version java version "1.8.0_271" 64 bit so I think i copied the correct JAR file.

       

      Where could I download these files?

       

      Thank you!

       

       

      • sonya_m's avatar
        sonya_m
        SmartBear Alumni (Retired)
        4 years ago

        Thanks Richie, Chris! 

         

        PG Were you able to solve this? Please share your solution with us.

        Or, if you didn't, opening a support ticket is a good next step.