I have application in ASP.NET (C#) in which I use Sap Crystal Reports for Visual Studio. In VS everything works perfect. But when I deploy it to IIS “Database Logon Failed” error occurs. When I set CrystalReportViever “Enable Database Logon Prompting” it keeps me asking for username and password but doesn’t generate an error, nor shows the report. I am setting “Enable Database Logon Prompting” for testing purpose only otherwise I sending logon parameters by
ReportDocument.SetDatabaseLogon(user, password, “my dsn name”, “”). Again, everything works perfect in VS.
I am using:
– Windows 7 Enterprise 64 bit
– Visual Studio 2010 (C#)
– Sap Crystal Reports, version for VS 2010
– My App pool identity in IIS is NetworkServise
– I am pooling data from Oracle Stored Procedure
– I am using System DSN to connect to database