System.Runtime.InteropServices...

See more:

ASP.NET

CrystalReports

reporting

Hi All,
Hope all you are doing well.
I am getting stuck with below problem.
I have created a ASP.net Application and use Crystal report to generate report in PDF format.
When I run the code it is working fine on ASP.NET inbuilt server and generated the PDF file.
But when I've deployed the site on My Local IIS server and try to generate PDF then it showing below Error:

System.Runtime.InteropServices.COMException (0x800002F4): Failed to open the connection. Failed to open the connection. Payroll {E077DA72-5194-440B-AD1C-F777039C0E5E}.rpt at CrystalDecisions.ReportAppServer.Controllers.RowsetControllerClass.CreateCursor(ISCRGroupPath GroupPath, RowsetMetaData MetaData, Int32 Reserved) at CrystalDecisions.ReportAppServer.CrystalReportDataView.EnsureDataTableIsFilled() at CrystalDecisions.ReportAppServer.CrystalReportDataView.get_DataView() at CrystalDecisions.ReportAppServer.CrystalReportDataView.get_InternalCollection() at CrystalDecisions.ReportAppServer.CrystalReportDataView.get_Count() at SessionalWorker_Reports.btnDownload_Click(Object sender, EventArgs e)

I have Set up DSN in ODBC data sources (32-bit) to connect crystal report with DB.

It is working in ASP.NET inbuilt server, but not working after deploying to my local IIS server.

If I changed IIS Server setting that is
Application Pool--><<Sitename>>-->Advanced Setting-->Identity-->Add Custom Account[provide system username,password]
and then run the site from IIS then its working and PDF is generated.

But I can't provide the custom Account Identity under Application.
There is some authentication setting problem.

Crystal Reports version 13.0, .NET 4.0, SQL Server 2008 Express, VS 2012.

Any help would be much appreciated.