Invalid object name #<temp table> when executing query

When executing a SQL Server db query I get an :Invalid object name #" message.

The connection string uses windows AD authentication and the query works in SQL Server Management Studio using the same credentials.

Any ideas as to why this does not work on KS?

Hi @searchlumin70,

I think you should put the default database name in the connection string. Please read this post for further explaination:

I tried the suggestion of adding the default database into the connection string, but same result.

There is no issue when running the query in SSMS. Also, Katalon can fetch the data if the query does not contain temporary tables.