Ask a Question

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

SOLVED
jkgupta0003
Occasional Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
jkgupta0003
Occasional Contributor

Re: SoapUI JDBC Connection throwing error "This driver is not configured for integrated authent

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

View solution in original post

3 REPLIES 3
rupert_anderson
Valued Contributor

Re: SoapUI JDBC Connection throwing error "This driver is not configured for integrated authent

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

Author of SoapUI Cookbook
jkgupta0003
Occasional Contributor

Re: SoapUI JDBC Connection throwing error "This driver is not configured for integrated authent

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

View solution in original post

SuperSingh
Contributor

Re: SoapUI JDBC Connection throwing error "This driver is not configured for integrated authent

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 

cancel
Showing results for 
Search instead for 
Did you mean: