title: T-SQL Server Agent Job fails "User does not have permission to perform this action"
body: <p>I have setup a T-SQL job in the SQL Server Agent to run weekly. Within SQL Server Management Studio I am able to run the script successfully as a query but when the job runs it errors out saying:</p>
  
  <blockquote>
    <p>“Executed as user: DOMAIN\user. User does not have permission to
    perform this action. [SQLSTATE 42000] (Error 15247).  The step
    failed.”</p>
  </blockquote>
  
  <p>The script is exporting table data from one SQL server and dumping it into another linked server. From what I gathered T-SQL doesn't use proxies and credentials, it uses the owners login when performing the script I am db_owner on both databases and sysadmin and serveradmin on both servers, what am I missing?</p>