TSQL Jobstep failed by Query over Linked Server

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  August 18, 2017 at 4:51 am

  #332294

  Hi,
  a Job-Step is runnig a Query with joining a Table on a Linked-Server.
  with the following:
  Message
  Executed as user: DOMAIN\SQLServerAgent. Login failed for user DOMAIN\SQLServerAgent'. [SQLSTATE 28000] (Error 18456). The step failed.
  I think, a Proxy_User does not support T-SQL ??

  Can anybody tell me,  what i have to do ?

  Thanks
  Regards
  Nicole  :doze:

• Ant-Green

  SSC Guru

  Points: 112965

  More actions

  August 18, 2017 at 5:16 am

  #1955806

  You will just need to add the SQL Agent account access to the server and database on the other side of the link.

  Alternatively you can modify the link to have a setting to impersonate a user if a local impersonation doesn't exist.