Forum Discussion
I changed the end of the connection string to Trusted_Connection=Yes. I now get 'Failed to get a connection for the specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xxx\xxxxx'. ClientConnectionId:31d9dcf4-5be7-4bbc-98a6-2d2d3006eb1d
I checked with our DBA and he is seeing no connection attempts with that user.
- richie4 years agoCommunity HeroHey rvandenbosch,
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- rvandenbosch4 years agoOccasional Contributor
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
- richie4 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
Related Content
Recent Discussions
- 13 days ago
- 16 days ago