The most recent content from our members.
If you're in a situation where you would like SQL Auditor and LEM to be able to work with MS SQL 2012, please up-vote!
We recently fired up a new virtual SQL server (2008 R2) and need to start auditing sql authentication failures. I went to set it up the same as the other SQL (2008 R2 also) server, which we are auditing currently, and got this error message: You do not have permission to run 'FN_TRACE_GETINFO' when testing the Auditor…
Anyone else have problems running MSSQL Auditor along side TSQL based log shipping jobs? We have log shipping jobs running every 30 minutes from our prod to our dr site. As long as the MSSQL Auditor tool is running the jobs fail. Once Auditor is disabled the jobs work again.
Hi All, I am due to install MS SQL auditor for LEM and use it to monitor changes to tables and schemas and wondered if anyone else has had any experiences with this agent? I am also wondering if there are any known limitations for the auditor and if it has to be installed on the SQL server, or if it can be deployed…
It looks like you're new here. Sign in or register to get started.