Forum Discussion
Are you using the .dll as well as the .jar file to connect? Its been a while, but if i remember correctly you need both for windows auth for an sqlserver connection.
Ta
Rich
Rich,
I am using both the jtds-1.3.1.jar & the ntlmauth.dll and have progressed to the following error: I get 'Failed to get a connection for the specified propertis:java.sql.SQLException:I/O Error: DB server closed connection
- richie3 years agoCommunity Hero
Hey rvandenbosch
Ok - I have a couple of points:
Whenever I try and create a new DB connection in ReadyAPI!/SoapUI and I'm having problems. I stop working with ReadyAPI!/SoapUI and try setting up the connection in a DB interrogation tool like TOAD or DBVisualiser, etc., etc. Doing this means that you haven't got the extra layer of complication.
Whatever works in the DB interrogation tool will work in ReadyAPI! (unless you've done something like copied the driver files to the wrong directory) - so I would suggest trying to configure your connection first in DBVisualiser - it simplifies things.
Next, can you please publish the connection string/URL you're using to try and connect?
Next, can you confirm if you've tried with the JDBC driver instead of the JDTS driver?
Next, can you confirm the JRE you're running to enable the driver files to execute is the correct version for those drivers?
Next, this sounds a bit of a stupid one, but it's easier than you think to make a mistake on this one, can you confirm you're Java bit type (either x86 or 32bit) matches your ReadyAPI! instance please?
Cheers,
Rich
- sonya_m3 years agoSmartBear Alumni (Retired)
Related Content
Recent Discussions
- 16 hours agogroovyguy