I have a job called @test_credentials which runs the following query
select * from openquery(SERVER2, 'select USER_NAME(),* from openquery(SERVER1,''SELECT USER_NAME() '')')
and outputs those results to a file.
Job '@test_credentials' : Step 1, 'test_credentials' : Began Executing 2015-08-31 17:53:45
(1 rows(s) affected)
- The linked server definitions for both
SERVER2are using the linkedserveruser to login to one another (security context option).
- Both linked server definitions are defined with the same options
- The linkedserveruser user account exists on both servers and is not disabled in anyway.
- The service account running the AGENT is identical for both
So my question is this:
Why is SQL Server Agent logging in as guest on SERVER2 when executing this job?