I write a report in Crystal XI and I use ODBC to connect to a SQL database.
I use Integrated Security and the report runs ok in Crystal.
I import the report into the web application and attempt to run it.
The error displays:
Report was not cached successfully - Database logon failed
I go back to my report and change from Integrated to a SQL login, again it runs successfully in Crystal, but when I try and run it via the web app, the same message appears.
The error in the log is:
CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon failed. ---> System.Runtime.InteropServices.COMException (0x8004100F): Database logon failed.
I am not sure what security I should be using as neither seems to be working. Any ideas?