Microsoft SQL Interface

Discussion created by MuckMoses on Feb 7, 2017
Latest reply on Feb 13, 2017 by Pete Wirfs
Hi All

I'm new here.  We at Lowell got Automic 11 in November 2016. I've had the Basic training course and have now got some experience with Automic. Nothing clever yet. I'll apologise for the stupid questions in advance.

We're trying to connect a job object to a MSSQL database.  We have a connection object that tells me "Connect test was Successful" so I was expecting happy times but when I try and run a simple SQL select statement I get the following message.
"(RunID '0001084718') on Host 'SQL01' aborted (return code='0000000102').  Remote status=Waiting for Database and the task fails"

Anyone got any ideas what this means & how to fix it.