sql server 2008 database-JDBC step -integrated security true

Hi,

Please check this link:
http://stackoverflow.com/questions/4629 ... dbc-driver

There is also a sqljdbc_auth.dll you need to copy over to a directory on the system path. So you may need to copy that dll to the <soapui install>\bin folder.



Regards,
Marcus
SmartBear Support

hi

i added the bin path to env variables and i am getting the below error

com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [sqljdbc_auth], connectionString [jdbc:sqlserver://SQLDB;databaseName=ZZZ;integratedSecurity=true;]

appreciate the help.

Hi,

Please double check that you copied the correct dll (32 or 64 bit depending on what version of SoapUI you are using) into the <soapui install>\bin directory.




Regards,
Marcus
SmartBear Support

hi

would you be able to point me where i can download the 64 bit sqljdbc_auth - i tried searching and am not able to find the download link

thanks

Hi,

Please see this link:
http://msdn.microsoft.com/en-us/library ... integrated

The sqljdbc_auth.dll files are installed in the following location: <installation directory>\sqljdbc_<version>\<language>\auth\

Regards,
Marcus
SmartBear Support

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.

Hi,

The dll is not going to be picked up in the C:\Program Files\SmartBear\soapUI-Pro-4.6.0\ext directory as that is for jar files.

In Help -> System properties, look for JAVA property java.library.path. That is where you need to copy the sqljdbc_auth dll file. For my SoapUI Pro 4.6.2 installation it is C:\Program Files\SmartBear\SoapUI-Pro-4.6.2/bin. Copy over the bit version that matches the bit version of SoapUI Pro you are using. Also, I see you have listed two sqljdbc jar files you are using. Only one should be used, and copied into the ext directory. From the information in this link http://technet.microsoft.com/en-us/libr ... 78422.aspx,

Use sqljdbc4.jar when your application must run on JRE 6.0 or 7.0, even if your application does not use JDBC 4.0 API features.

sqljdbc4.jar should be used in the ext directory since SoapUI 4.6 uses JRE 7.


Regards,
Marcus
SmartBear Support