sql server job failed. Here is the log. what caused the issue and how to fix?

bestrongself 1 Reputation point
2020-11-24T20:46:25.053+00:00

SQL server agent job failed-- that job runs a stored procedure. And stored Procedure failed in the middle.

Here is the log

2020-11-24 03:00:27.87 spid58 Setting database option SINGLE_USER to ON for database 'DatabaseA'.
2020-11-24 03:00:27.91 spid58 Process ID 55 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.91 spid58 Process ID 61 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 63 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 64 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 66 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 89 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 90 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 55 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 64 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.92 spid58 Process ID 66 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.93 spid58 Process ID 89 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.93 spid58 Process ID 90 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 55 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 64 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 66 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 89 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 90 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 55 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 64 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 66 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 89 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 90 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 55 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 64 was killed by hostname ServerA, host process ID 13352.
2020-11-24 03:00:27.94 spid58 Process ID 66 was killed by hostname ServerA, host process ID 13352.

2020-11-24 03:00:27.99 spid58 Setting database option SINGLE_USER to ON for database 'DatabaseA'.
2020-11-24 03:00:28.05 Logon Login succeeded for user 'domain\user1'. Connection made using Integrated authentication. [CLIENT: 192.168.1.10]
2020-11-24 03:00:28.77 Logon Login succeeded for user 'domain\user1$'. Connection made using Integrated authentication. [CLIENT: <local machine>]
2020-11-24 03:00:29.16 Logon Login succeeded for user 'domain\user1'. Connection made using Integrated authentication. [CLIENT: 192.168.1.10]
2020-11-24 03:00:30.13 Logon Error: 18456, Severity: 14, State: 38.
2020-11-24 03:00:30.13 Logon Login failed for user 'domain\user1'. Reason: Failed to open the explicitly specified database 'DatabaseA'. [CLIENT: 192.168.1.10]

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ronen Ariely 15,096 Reputation points
    2020-11-24T21:58:04.83+00:00

    Good day

    For some reason many people that come to the forums think that the people behind the screens have the ability to read minds and see their code. It might be an unknown fact, so don't tell it to anyone, but the truth is that we cannot read your mind in order to read your code and we cannot see your screen unless you provide screenshot 🙃

    Please provide the details about the job and you SP and the relation to the server/database and users

    in the mean time I recommend to go over Erland's suggestion in this thread regarding the same error message:

    https://social.msdn.microsoft.com/Forums/SECURITY/en-US/998d38e9-5b1d-45a5-9acb-a4791db498df/logon-login-failed-for-user-xyz-reason-failed-to-open-the-explicitly-specified-database?forum=sqlsecurity

    1 person found this answer helpful.