I have an MS Access database on a shared network location which I've added as a linked server to my SQL Server instance. I'm authenticated on the network location via the server's main Windows login.
I can run the stored procedure normally via SSMS on the server, which works perfectly. However, when I try and run the job through SQL Job Agent, it fails, I believe due to the fact that Job Agent runs under the Local Service account.
How can I allow only this one job to run under the Windows account without having to change this for all the other jobs? And should I even be doing it this way from a security standpoint?