Forum Discussion

Dmitriy Manushin's avatar
Dmitriy Manushin
Copper Contributor
Aug 13, 2025

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

Resources