JDBC Step - Problem Connecting
Good Afternoon, I'm attempting to connect to Microsoft SQL Server. I've downloaded the correct sqljdbc4.jar library and have tried doing this with both Groovy and the JDBC Request with no success...
Forum Discussion
nmrao
Champion Level 2
Champion Level 2Not sure what is the error you are getting.
1. check if you have copied jar file under READYAPI_HOME/bin/ext directory.
2. restart ready api
3. Register the driver using below statement before sql instance
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("com.Microsoft.sqlserver.jdbc.SQLServerDriver")
4. change to (note only 3 arguments instead of 4) Sql.newInstance(db_url,db_username,db_password)
1. check if you have copied jar file under READYAPI_HOME/bin/ext directory.
2. restart ready api
3. Register the driver using below statement before sql instance
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("com.Microsoft.sqlserver.jdbc.SQLServerDriver")
4. change to (note only 3 arguments instead of 4) Sql.newInstance(db_url,db_username,db_password)
Here's the error message I'm getting:
org.codehaus.groovy.runtime.InvokerInvocationException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host VMBKSA69901M4Y, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
- nmraoYou can follow the instructions of error message.