Post reply

SQL job error - NT AUTHORITY\NETWORK SERVICE. Login failed

  • October 11, 2012 at 9:44 am

    #263188

    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

  • October 18, 2012 at 7:43 am

    #1550489

    Does anyone have any idea ? I still cannot seem to run the jobs as it ends with the above error

  • October 22, 2012 at 8:23 am

    #1551392

    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.

  • October 22, 2012 at 11:38 am

    #1551559

    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