Toad World® Forums

SQL Server Authentication Error When Multiple Agents Configured

When I enable a second agent, the job fails during the load phase with an authentication error. I setup my DSN to use windows session authentication. What is the proper way to setup authentication to allow the remote agent to access the database?

Agent(BENCHFACTORY2) Error: ODBC Error (28000,4818) - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.

Are you specifying in the Agent setup an NT account to use?

No I am not, I was using windows authentication, I believe I will have to change that and use sql authentication and create a user for that.