This content has been marked as final. Show 3 replies
I think you should check if you are following these guidelines:
When using a Microsoft SQL Server 2005 or later database, ensure that the database uses mixed-mode authentication.
Local monitoring uses a source IP address of 0.0.0.0, and port 0, for statements originating from a console user or other process. The destination address (displayed in the traffic log) is the same as one of the protected databases being monitored.
Local monitoring does not record duplicate SQL statements. It only records the last SQL statement in a set of duplicate SQL statements.
Local Monitor does both a forward and reverse DNS lookup to determine if a session is from the local machine. If a DNS configuration is broken and prevents the server from doing the lookup successfully, then the Local Monitor cannot record console events. To ensure that Local Monitor records all local sessions, check that your DNS configuration is correct.
If you do, then tell me.
If you have any questions, ask.