OpenVPN as SQL Agent job

How to customize and extend your OpenVPN installation.

Moderators: TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech

Post Reply
wittygiddy
OpenVpn Newbie
Posts: 1
Joined: Mon May 15, 2023 7:50 pm

OpenVPN as SQL Agent job

Post by wittygiddy » Mon May 15, 2023 7:57 pm

I have created a process in SSIS package that connects OpenVPN, run a few scripts on a remote server then disconnect. This works just fine in the SSIS package but doesn't work when I deploy it and run the agent job. Does anyone have any idea why this isnt working? The same account used to run the SSIS package is the same account running the agent job.

azanni67
OpenVpn Newbie
Posts: 1
Joined: Wed Aug 02, 2023 6:52 am

Re: OpenVPN as SQL Agent job

Post by azanni67 » Wed Aug 02, 2023 6:54 am

The SQL Server Agent job might be running in a different environment compared to when you execute the SSIS package manually. Ensure that the environment variables, paths, and configurations necessary for the SSIS package to function properly are consistent between the two scenarios. If the SSIS package interacts with external resources, such as a remote server, make sure that any necessary proxy accounts or credentials are set up correctly in the SQL Server Agent. screen mirroring oppo The execution context of the SQL Server Agent job might differ from your manual execution. Be aware of potential differences in paths, working directories, and user contexts.

Post Reply