dbTalk Databases Forums  

Security Failure Audit errors from SQL Agent - SQL Server 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Security Failure Audit errors from SQL Agent - SQL Server 2005 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Randy Martin
 
Posts: n/a

Default Security Failure Audit errors from SQL Agent - SQL Server 2005 - 01-10-2006 , 09:18 AM






I am getting Failure Audit items of several flavors from SQL Agent when
running SSIS packages. In addition, it causes the SSIS jobs to fail.

We are using the local groups established by SQL Server 2005 install to
secure the domain account used for the agent. I assume that we have a
GPO that is causing this, but would like to present the evidence to get
the GPO changed.

Env: Windows 2003 SE SP1, SQL Server 2005 EE November RTM

TIA, Randy


Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 1/10/2006
Time: 6:53:37 AM
User: Domain\SQLAgentAccount
Computer: COMPUTERNAME
Description:
Object Open:
Object Server: Security
Object Type: File
Object Name: C:\WINDOWS\system32\CCM\FrameworkPerf.dll
Handle ID: -
Operation ID: {0,2937378}
Process ID: 3300
Image File Name: C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
Primary User Name: SQLAgentAccount
Primary Domain: Domain
Primary Logon ID: (0x0,0x2C2382)
Client User Name: -
Client Domain: -
Client Logon ID: -
Accesses: ReadAttributes

Privileges: -
Restricted Sid Count: 0
Access Mask: 0x80


Another example:

Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 1/10/2006
Time: 6:53:37 AM
User: Domain\SQLAgentAccount
Computer: COMPUTERNAME
Description:
Object Open:
Object Server: Security
Object Type: File
Object Name: C:\
Handle ID: -
Operation ID: {0,2938118}
Process ID: 3300
Image File Name: C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
Primary User Name: SQLAgentAccount
Primary Domain: Domain
Primary Logon ID: (0x0,0x2C2382)
Client User Name: -
Client Domain: -
Client Logon ID: -
Accesses: SYNCHRONIZE
ReadData (or ListDirectory)

Privileges: -
Restricted Sid Count: 0
Access Mask: 0x100001


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.