I am integrating SQL 2000 with Mcafee SIEM using McAfee Windows Agent using SQL utility.After the initial configuration I am unable to receive the logs.After looking at the DEBUG Logs, I found the below error message
GetNextRecordData Failed to retrieve next record: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. - at GenericSQLGenerator.MSSQLDBAccess.ExecuteQuery(String query, DataTable& ds)
at GenericSQLGenerator.Configuration.ExecuteQuery(String p, DataTable& ds)
I checked the time format on both the servers i.e. Agent as well as the Server and its same.
Has anyone faced similar issues.