SQL Server Agent Job Failing with Linked Server Error 7437 and Impersonation Issues
1
vote
0
answers
149
views
I have two servers, ServerA and ServerB, both of which are part of the same domain (test). For both servers, the SQL service account and SQL Agent service account are configured to use the domain account test\SQLAdmin. I want to establish a connection from ServerA to ServerB using Windows Authentication and linked server. For this purpose, I am utilizing the domain user account test\sqljobowner.
When I created a linked server using ServerB's FQDN on ServerA, with locallogin=test\sqljobowner and enabled the impersonate flag, the connection test was successful. Next, I set up a SQL Server Agent job on ServerA, configured to run daily. This job has test\sqljobowner as its owner and inserts data into a table on ServerB. However, the job fails at the execution step with the following error:
> Executed as user test\sqljobowner. Linked servers cannot be used under
> impersonation without mapping for the impersonated login. (Error 7437)
Update:
For the Server I am using SQL service account is test\SQLADMIN.
and in the AD server for the test\SQLADMIN user Delegation is enabled added both server as MSSQLsvc type
I am using SQL Server 2022 Developer Edition with CU10.
linked server connection:

Asked by Mangesh Auti
(111 rep)
Mar 24, 2025, 11:46 AM
Last activity: Mar 25, 2025, 08:44 AM
Last activity: Mar 25, 2025, 08:44 AM