SQL Agent Job fails when using a proxy under certain conditions

Question

SQL Agent Job fails when using a proxy under certain conditions

Lewie Egerton 0

I have an Agent Job configured on a Server Instance that runs an SSIS package that contains a 3rd party plugin (Kingswaysoft for salesforce).

The Agent Jobs runs with the owner set to Credential configured in Security and there is a proxy associated with it.

The Agent Job step runs as the configured proxy.

When the package runs it gets to the 3rd party piece but then fails after a timeout period due to the lack of reply from what ever the 3rd part software is accessing (Salesforce).

The problem I have is that when someone is logged into the server instance\machine that the Agent Job is on and I run the agent job from my own machine there are no issues. The 3rd party plugin works perfectly with the proxy. If you then log out of that instance\server and I attempt to run the Agent Job from my machine again the 3rd part plugin fails after a timeout period. I assume somehow it is an access\credential issue but not sure. Its not the 3rd party software as it works when someone is on the server instance.

The 3rd party software is a plugin from Kingswaysoft that connects to Salesforce however I don't believe its the issue.

The error refers to a Send Failure as the underlying connection was closed

1 answer

Your answer

Answer 1

ZoeHui-MSFT 41,481

Hi @Lewie Egerton,

Is there any error message?

Could you please make the Proxy a member of the Local Administrators group on the server and then try to run the job?

Or please delete the job and re-create it for a try.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Lewie Egerton 0 Reputation points

2023-06-07T23:19:58.9566667+00:00
The proxy is a member of the Local Admin Group. The issue is also on another machine with the same setup so I don't believe redoing the Agent Job would help.

The problem user access (admin or other) to the host is remote only.

The problem user is a domain admin account part of the local admin.

The problem user has log on as a service policy

The problem domain user is assigned as the identity of the credentials used by the proxy.

It appears - when the problem domain user logins remotely - can successfully run the jobs via the assigned proxy, then logs off the remote session, the password for the identity is changes. But it's hard to say if that's the problem or is it just the fact that to fix the problem we start a remote session with the problem domain user to fix the issue and only works at that point cause we're actually logged in remotely.

We suspect it's a double hop issue given the problem arises when attempting to execute the job (with the assign proxy) via a remote SSMS session.
Lewie Egerton 0 Reputation points

2023-06-07T23:25:27.4166667+00:00

,An error occurred with the following error message: "KingswaySoft.IntegrationToolkit.Salesforce.Rest.SalesforceRestServiceException: The underlying connection was closed: An unexpected error occurred on a send. (Error Type / Reason: SendFailure, Detailed Message: The underlying connection was closed: An unexpected error occurred on a send.) (SSIS Integration Toolkit for Salesforce, v21.2.0.31501 - ISServerExec, v13.0.6300.2)

Share via

SQL Agent Job fails when using a proxy under certain conditions

1 answer

Your answer