While using the ContextGroup & context variables in my jobs for the DB connections; at runtime the error is - 'The Network adapter could not establish the connection'. However the connections are successful when tested individually. what could be the possible reason?
Are you executing it locally? or on a remote server.
It could happen on a remote server as the connection between remote server and database server may be blocked.
Are you using IP address or DNS name? if it is DNS name whether has it been added to the host file?
This is the only reason I can think of.