SQL Server Audit Log Event ID 24001
SourceSQL Server (LOGbinder SQL)
Action GroupSUCCESSFUL_LOGIN_GROUP
Windows Security Log
Category
 • Subcategory
Object Access
 • Application Generated
Type Success
Discussions on Event ID 24001
Ask a question about this event

24001: Login succeeded

This is a SQL Server audit event from LOGbinder SQL generated by Action Group  SUCCESSFUL_LOGIN_GROUP.

On this page

A principal successfully logged in to SQL server

Field Description
Occurred When event was reported by SQL Server
User  
Session ID ID of the session on which the event occurred
Target object  
  ID Target object ID
  Name Target object name
  Type Target object type
Set options  
Additional information Any additional information about the event, stored as XML.

Top 10 Windows Security Events to Monitor

Login succeeded
A principal successfully logged in to SQL server
Action Group: SUCCESSFUL_LOGIN_GROUP
Occurred: 6/27/2012 3:50:09.0000000 PM
User: SP2010\sharepoint
Session ID: 57
Target Object
  ID: 263
  Name: SP2010\sharepoint
  Type: Login
Set options: -- network protocol: TCP/IP; set quoted_identifier on; set arithabort off; set numeric_roundabort off; set ansi_warnings on; set ansi_padding on; set ansi_nulls on; set concat_null_yields_null on; set cursor_close_on_commit off; set implicit_transactions off; set language us_english; set dateformat mdy; set datefirst 7; set transaction isolation level read committed
Additional information: <action_info xmlns="http://schemas.microsoft.com/sqlserver/2008/sqlaudit_data"><pooled_connection>1</pooled_connection><client_options>0x28000020</client_options><client_options1>0x0001f438</client_options1><connect_options>0x00000000</connect_options><packet_data_size>4096</packet_data_size><address>10.42.1.32</address><is_dac>0</is_dac></action_info>

For more information, see http://logbinder.com/support

Keep me up-to-date on the Windows Security Log.
Email*:
*We will NOT share this

Where Does This Event Come From?

This Event Is Produced By