SQL Agent Job fails when using a proxy under certain conditions

Lewie Egerton 0 Reputation points
2023-06-01T23:58:51.5866667+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,343 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,546 Reputation points
    2023-06-02T06:17:12.2533333+00:00

    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.