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

[jkgupta0003]

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.

[rupert_anderson]

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 · Accepted solution]

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]

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