Problem: SQL Server 2014, synchronized data from Linked Server with Job timing, executed times “Login Failed for User ‘domain account’ “(SQLSTATE 28000) (Error 18456).
Solution: Modify the SQL Server Agent service startup account as the domain account through the configuration management tool, see: Login Failed for [SQLSTATE 28000] (Error 18456) The Step Failed

Reproduced in: https://www.cnblogs.com/abelard/p/4840962.html