Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Write Server Audit Events to the Security Log Expand / Collapse
Author
Message
Posted Wednesday, October 30, 2013 11:54 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:32 AM
Points: 315, Visits: 193
I have a requirement to have all login events written to the Windows security log. I have looked at numerous articles and followed the steps outlined (http://technet.microsoft.com/en-us/library/cc645889%28v=sql.100%29.aspx) in the post. I still have not had any luck getting the results I am looking for. What am i missing? IS there a piece I have not addressed? I can see all the login failures in the application log but not the successes which is a requirement. I also need this into the security log!

Any help would be phenomenal!


Kindest Regards,
David

** Obstacles are those frightening things that appear when we take our eyes off the goal. **

Post #1509901
Posted Thursday, October 31, 2013 1:00 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
I am not much comfortable with Sql Audit feature. I would suggest to use native auditing (Properties->Secutiry-> Both failed and Successful logins)
Post #1510041
Posted Thursday, October 31, 2013 5:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:32 AM
Points: 315, Visits: 193
I already have that. The requirement is to use the Windows Security event log.

Kindest Regards,
David

** Obstacles are those frightening things that appear when we take our eyes off the goal. **

Post #1510121
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse