MSSQL collector only reading events once
I need some help. I set up mssql server 2005 collector, with the correct path, correct Error logfile name, reading mode is monitor single file log, and reading from last position. When i set it up first time, events were read..but now they are not reading the events in realtime as i expected.
Question: Should do anything on the SQL Server, like add a port to listen to..or what should i do?My aim is to have realtime logs streaming in.