Hi guys, am new to Katalon Studio and am trying to follow the various tutorials out there but am struggling to figure it all out as they seem a bit too incomplete for a newbie.
For reference I followed these 3 links to progress as much as I could:
I basically want to have Katalon Studio automatically connect to the SQL Server database, run a script, then close the connection.
So far under keywords I have added this, I changed ‘mysql’ to ‘sqlserver’ - SEE keyword.txt attachment.
And for the test script see the attached testscript.txt file.
The error I get is:
Test Cases/demo FAILED because (of) org.codehaus.groovy.runtime.InvokerInvocationException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 10.62.xx.xxxx/databasename, port 1433 has failed. Error: “null. 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.”.
I have tried disabling firewalls on both desktop and server, I can ping the server and connect to it from my local desktop.
Thanks for looking!