Forum Discussion

vd484's avatar
vd484
Occasional Contributor
13 years ago

sql server 2008 database-JDBC step -integrated security true

hi i am trying to connect to a Sql database using the JDBC step with integrated security set to true using the driver : sqljdbc_auth Connection string : jdbc:sqlserver://SQLDB;databaseName=XXXX...
vd484's avatar
vd484
Occasional Contributor
13 years ago
hi

i downloaded the sqljdbc_4.0 files and add copied the below jar and dll into C:\Program Files\SmartBear\soapUI-Pro-4.6.0 and C:\Program Files\SmartBear\soapUI-Pro-4.6.0\ext folders
sqljdbc.jar
sqljdbc4.jar
and X64 sqljdbc_auth.dll

i also copied them into c:\windows\system32

i added the jdbc step in the test and am using
Configuration : None
Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String : jdbc:sqlserver://SQLDB;databaseName=AAA;integratedSecurity=true;
and when i click on testconnection - i get the below error


com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:0cdffbe0-28c0-43bf-a349-37cb98109d84

appreciate the help.