Katalon Version 7.6.6
Created customkeyword to connect to the database and then called the same in Test case to execute. here is my code
CustomKeywords.‘packagename.keywordname.connectDB’(“servername”, “db”, “username”, “password”)
def recordset = CustomKeywords.‘packagename.keywordname.executeQuery’(“select count(*) from users”)
while (recordset.next())
{
Object person = recordset.getObject(“person”)
if (person != null)
println(">>>>>" + person)
}
Error in console
2020-09-10 19:25:02.552 ERROR k.k.c.m.CustomKeywordDelegatingMetaClass - 
com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host xxxx, named instance xxxxxx failed. Error: “java.net.SocketTimeoutException: Receive timed out”. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
2020-09-10 19:25:02.555 ERROR c.k.katalon.core.main.TestCaseExecutor - Test Cases/SQL FAILED.
Reason:
org.codehaus.groovy.runtime.InvokerInvocationException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host xxxxxx, named instance xxxxx failed. Error: “java.net.SocketTimeoutException: Receive timed out”. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
at sqlConnection.QueryInSQL.invokeMethod(QueryInSQL.groovy)
at com.kms.katalon.core.main.CustomKeywordDelegatingMetaClass.invokeStaticMethod(CustomKeywordDelegatingMetaClass.java:50)
at SQL.run(SQL:19)
at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194)
at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119)
at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:339)
at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:330)
at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:309)
at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:301)
at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:235)
at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:114)
at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:105)
at com.kms.katalon.core.main.TestCaseMain$runTestCase$0.call(Unknown Source)
at TempTestCase1599791084620.run(TempTestCase1599791084620.groovy:25)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host xxxxxx, named instance xxxxx failed. Error: “java.net.SocketTimeoutException: Receive timed out”. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:227)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(SQLServerConnection.java:5241)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.primaryPermissionCheck(SQLServerConnection.java:1916)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1669)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1528)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:866)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:569)
at java_sql_DriverManager$getConnection.call(Unknown Source)
at sqlConnection.QueryInSQL.connectDB(QueryInSQL.groovy:44)
… 14 more
2020-09-10 19:25:02.559 INFO c.k.katalon.core.main.TestCaseExecutor - END Test Cases/SQL