Forum Discussion

jkgupta0003's avatar
jkgupta0003
Occasional Contributor
9 years ago
Solved

SoapUI JDBC Connection throwing error "This driver is not configured for integrated authentication."

I am using open version of SoapUI version 5.1.3
I have placed JDBC driver for SQL Server: sqljdbc4.jar : C:\Program Files (x86)\SmartBear\SoapUI-5.1.3\bin\ext
copied sqljdbc_auth.dll inside this path: C:\Program Files (x86)\SmartBear\SoapUI-5.0.0\bin

Restarted the SoapUI

Added the Test step: JDBC Request
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String: jdbc:microsoft:sqlserver://server:portname;databaseName=db name;IntegratedSecurity=true
but it's not working for me getting error: Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

Pls. help me on this. I'm badly stuck on this.

  • jkgupta0003's avatar
    jkgupta0003
    8 years ago

    Thanks Rupert for your reply.

    However problem was due to sqljdbc.jar file. Version wasn't compatible with the SoapUI 5.1.3 version. I replaced the jar and it's working for me.

     

    Regards,

    Jitendra

3 Replies

Sort By
  • rupert_anderson's avatar
    rupert_anderson
    Valued Contributor
    9 years ago

    Hi,

     

    I am not MS SQL expert and don't have it to test, but is that IntegratedSecurity=true flag not causing the issue? As the error mentions not being configured for integrated authentication. 

     

    Also on the wiki the MS SQL connection string doesn't have this http://www.soapui.org/jdbc/reference/jdbc-drivers.html

     

    Sorry if this turns out to be off beam! 

     

    Cheers,

    Rupert

    • jkgupta0003's avatar
      jkgupta0003
      Occasional Contributor
      8 years ago

      Thanks Rupert for your reply.

      However problem was due to sqljdbc.jar file. Version wasn't compatible with the SoapUI 5.1.3 version. I replaced the jar and it's working for me.

       

      Regards,

      Jitendra

      • SuperSingh's avatar
        SuperSingh
        Contributor
        8 years ago

        Hi Jitendra,

         

        I am facing the same issue.

        It would be great of you if you could throw some more light on how this got fixed for you.

         

        How were you able to decide the suitable jar file ?

        Folders where you kept dll and jar files ? 

        Any changes you made to the Connection String and Driver. ?

         

        Any other information..(I might be missing something silly as well )

         

        Appreciate if you could help me out here !

         

        Thanks in advance !

         

        Thanks

        Predator