Forum Discussion
Dmitriy Manushin
Aug 13, 2025Copper Contributor
execution SP via linked server from SQL Job
Hello colleagues, we have next environment:
1. SQL Server standard edition 2022 16.0.4185.3.
2. SQL Server Job service running under domain managed service account. Category type is Data collector.
3. Job owned by [sa]
4. Job execute stored procedure using next command exec RemoteServer.[DB].[dbo].Load_RTL 0
5. Linked server RemoteServer is MS OLEDB Provider and configured to use (Be made using this security context). Login is a SQL Login with provided password.
When job is started, it trying to execute remote SP using SQL Server Agent account, but not linked account which I indicated above in line №5. Why and how to change this so remote SP executed using linked server account?
Thank you.
No RepliesBe the first to reply