DSXchange

thebird, i think the issue we're having is different from that. we are able to connect in server job using the same user. do you think i should still try the following steps from other link you gave me? Also i'm not quite following what i should do. do i have to create a WORKDB env variable..is that...

After adding the environment variable, do we have to restart the ds engine? does it help or no? we tried without restarting still same error.

Thanks for the quick response DSGuru79 and thebird.

We dont really have a ds admin, we pretty much do all of the admin stuff as well.

does it matter where $APT_TERA_SYNC_DATABASE is set?
do we have to link this variable somewhere else?