SQL job error - NT AUTHORITY\NETWORK SERVICE. Login failed
-
hello ,
I have transferred a job from one server to another and I get this error when trying to execute it.
Executed as user: NT AUTHORITY\NETWORK SERVICE. Login failed for user xxx\machinename$'. [SQLSTATE 28000] (Error 18456). The step failed.
Would anyone know what credentials are different from old to new server and if I need to change anything with the SQL agent?
Much appreciated
John
-
Does anyone have any idea ? I still cannot seem to run the jobs as it ends with the above error
-
Seems that you are using machine names for accounts so the error 'Login failed for user xxx\machinename$' relies on the old machine which doesn't have rights on the new server.
Are the servces running as local service or under a specific domain account such as SVC_SQL? Common practise is to use a dedicated service account for SQL and then run all services under that as required.
Hope this helps.
-
Thanks for your help! It seems I have mistakingly not given a linked server within the job a connection string....
Although the error was misleading
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply