Crystal Reports XI R2 and Crystal Reports 9 incorrectly generate non-critical connection error logs when set to run reports from SQL Server 2008.
Specifically, when Crystal Reports is connected to a SQL Server 2008 database it will serve the report correctly, but invisibly it will also generate an error log in SQL Server.
Although insignificant for just one report, this clutters up the error logs for no reason when there are several hundred Crystal Reports all doing the same thing.
As part of modernizing our company database infrastructure we updated our database server from SQL Server 2000 to SQL Server 2008.
Continue reading “Crystal Reports Generating SQL Server Error 18456 Severity 8 Error Logs”