I have created a scheduled task that gather data from the server that it's on. When I am try and run it I get the error:
Executed as user: NT SERVICE\SQLAgent$Instancename. Login failed for user 'Domain\Servername$'. [SQLSTATE 28000] (Error 18456). The step failed.
This is a SQL 2016 server standard, running in mixed mode.
There are other scheduled tasks on the server that run ok.
The login failure by Domain\Servername$ shows up in the error log on another server
Any help would be appreciated