SQL Server Audit Log Event ID 24017
24017: Add member to server role failed (action_id APRL class_type SG)
This is an event from
SQL Server
audit event from
LOGbinder SQL
generated by
.
On this page
An attempt to add a principal to a server role failed
Free Security Log Resources by Randy
| Field |
Description |
| Occurred |
When event was reported by SQL Server |
| Session ID |
ID of the session on which the event occurred |
| User |
|
| Server |
|
| Member |
Member added or removed |
| Role |
|
| |
ID |
ID of the role affected by this event |
| |
Name |
Name of the role affected by this event |
| Statement |
Transact-SQL statement |
Supercharger Enterprise
This Event Is Produced By
Which Integrates with Your SIEM
Add member to server role failed
An attempt to add a principal to a server role failed
Action Group: SERVER_ROLE_MEMBER_CHANGE_GROUP
Occurred: 7/24/2013 9:26:14.0000000 PM
Session ID: 56
User: LB\Administrator
Server: DEV2
Member: TestLogin1
Role
ID: n/a
Name: dummyrole
Statement: EXEC sp_addsrvrolemember TestLogin1, 'dummyrole'
For more information, see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=24017
Top 10 Windows Security Events to Monitor
Free Tool for Windows Event Collection