N
N
Nikita Rubinkovskiy2019-08-08 14:55:05
SQL Server
Nikita Rubinkovskiy, 2019-08-08 14:55:05

Why job MS SQL doesn't work?

Hello.
I create a job on the server to periodically update the database (MS SQL).
But when executing requests in a job that refer to another server, an error occurs:

Executed as user: NT SERVICE\SQLSERVERAGENT. Login failed for user 'DS\ML-005$'. [SQLSTATE 28000] (Error 18456)

Similar requests executed outside of job are executed normally.
What is the reason?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Z
zhaar, 2019-08-08
@zhaar

So we read what it says:
Login failed for user 'DS\ML-005$
' service user)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question