My SQL Server Agent job is running for long time and failing with Login issues

236 Views Asked by At

Please see the logs shown below for more information:

2020-04-23 13:13:56.97 spid10s     Starting up database 'tempdb'.
2020-04-23 13:13:57.42 spid10s     The tempdb database has 4 data file(s).
2020-04-23 13:13:57.42 spid10s     The tempdb database data files are not configured with the same initial size and autogrowth settings. To reduce potential allocation contention, the initial size and autogrowth of the files should be same.
2020-04-23 13:13:57.42 spid25s     The Service Broker endpoint is in disabled or stopped state.
2020-04-23 13:13:57.42 spid25s     The Database Mirroring endpoint is in disabled or stopped state.
2020-04-23 13:13:57.44 spid25s     Service Broker manager has started.
2020-04-23 13:13:58.22 Logon       Error: 18456, Severity: 14, State: 38.
2020-04-23 13:13:58.22 Logon       Login failed for user 'ZA\ZA_DataExtr_DAAD'. Reason: Failed to open the explicitly specified database 'DG4_40'. [CLIENT: 10.50.254.40]
2020-04-23 13:14:00.23 Logon       Error: 18456, Severity: 14, State: 38.
2020-04-23 13:14:00.23 Logon       Login failed for user 'ZA\ZA_DataExtr_DAAD'. Reason: Failed to open the explicitly specified database 'DG4_40'. [CLIENT: <local machine>]
2020-04-23 13:14:09.22 Server      Software Usage Metrics is enabled.

Thanks in advance.

0

There are 0 best solutions below