Since couple of days ago we configured a big process to be run non stop on VisualCron. It runs 7 different groups with lot of jobs and tasks inside, connecting to different servers, with cloned configurations. Configured a connection to be used as well as a credential (a valid domain account) for the trusted connection. Nevertheless we are having random errors related to an incorrect login. We double checked everything and the user used on the credential is a valid domain account. And the sql user has all needed roles on both the server and database. The jobs may run without flaw for half an hour and suddenly, a task that 10min was successfully executed now fails.
Msg 18452, Level 14, State 1, Procedure , Line 65536
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Exception in Task: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Do anyone has faced similar situation? Is there a solution for it? We are running out of options and thinking to switch to a sql agent job.