August 29, 2014 at 11:17 am
I created an audit that is writing to a file to capture failed and successful logins, but unfortunately it will not write to the log file. What I have done:
1. Enabled the audit and audit specification. Also tried disabling/enabling both or one or the other to get it to write to the log.
2. Granted the SQL Service Account full control to the folder on the server where it is writing the log file. Verified the service account has full control on the audit files it created.
3. Dropped and recreated the audit and audit specification.
4. Restarted SQL Services.
5. Verified the service account is in the local admin group.
If I restart services or disable/enable the audit then it will dump out the data to the log file and create a new audit log that sits at 0 KB until something is restarted or recreated. The QUEUE_DELAY is set to the standard 1000. I have the files also set to a plenty of room 500 MB max with rollover and a max of 10 files, with 6 GB still free to support the logs. I have used this script to set up audits on many other servers and it worked fine, so I am guessing a setting was changed elsewhere that is creating the issue since this is a development box. Other recommendations of things to look at?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply