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
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. 

      • PG's avatar
        PG
        Occasional Contributor
        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