MS SQL Server Audit Event: 24001

SQL » 24001: Login succeeded

24001: Login succeeded

Event 24001 occurs when a user successfully logs into an SQL server.

Action groups consist of all the relevant events together, making it easy for an administrator to identify an event's type just by looking at its action group. This particular event is generated by the SUCCESSFUL_LOGIN_GROUP action group. This event includes important information, like the:

  • Date and time at which the login occurred.
  • Session identifier of the event.
  • Name of the user who logged in.
  • ID, name, and type of the target object (in this case, the SQL server login).

MS SQL Server Auditing Tool

EventLog Analyzer is a comprehensive log management software with which you can centrally collect, analyze, and manage logs from all the different log sources in your network. You also get reports and alerts on your network security, making it a power-packed IT security tool.