sqlsql-serverssmsaudit

"item has already Been added" added in audit


I am trying to make Audit return logs, but always returns this error:

"item has already Been added. Key in dictionary: 'mndo' Key Being added: 'mndo'"

I used these commands to test with a "test" user.

USE Clinica_Medica

SELECT * FROM TEST WHERE Nome = 'OI';

In Audit the log returns empty and with this error, I tried with the User SA standard, with global policies and the same happens.

My build:

enter image description here

enter image description here

Both are enabled, what I did wrong?


Solution

  • The problem was that the audit profile in the C:/Audits folder, contained files from another instance of MicrosoftSQL db, was causing a conflict, this did not replace the file, I solved it by delting all the files in the folder.