MSSQL Database Multiple Audit DB issue
I am getting the following warning message in [WARN ][default.com.arcsight.agent.loadable.agent._MultiSQLServerTraceAuditingAgent][processQuery()] Failed to process query [[select TOP 1 * FROM ::fn_trace_gettable .......... \t$\sqltrace\sessiontrace_22415.trc', 1)]] on database URL[jdbc:odbc:SQLPROD], bitmechanic
Anyone has idea how to fix this.
Try to run the following SQL statement as the user created for accessing the database.
select TOP 1 * FROM ::fn_trace_gettable .......... \t$\sqltrace\sessiontrace_22415.trc'
I'm suspecting a permission issue on the SQL account or maybe the trc file itself.
Yes. I managed to get rid of it by uninstalling the exiting connector and reinstalling another one.. I managed to get sysadmin privilege on SQL and Full permissions on the folder level.. Also ensure that sql admin follows all the steps mentioned in the guide.. This should work..