I have a Windows Server 2003 x86 server running IIS6 and ASP.NET. On this server, I have two different web forms set up to export Crystal Reports to PDF.
My problem is that only one of these reports can run. For example, I open report 1 and can then reopen (generate PDF of) report1 as many times as I want. I cannot open report 2 - I get a "Database Logon Failed" error message. If I restart the server, I can generate a PDF of report 2 successfully and as many times as I want but report 1 will get a "Database Logon Failed" error message.
Has anyone seen this behavior before? My code is very concise and manually closes the report document (and forces the garbage collection to run) once the PDF has been generated. However, for some reason, the report is staying in memory and is trying to run again even though it has been closed. It is driving me crazy.
Thanks in advance for any assistance you can offer.