We are using CRYSTAL Report (13.0) through ASP.NET(4.0) on Win2008.
The Report files (RPT) are kept at UNC location on seperate machine, the database (SQL Server) is located on another machine. The ASP.NET based application access the database using SQL-Server Authentication.
The UNC location has share&full access for everyone.
The crystal-report (RPT) files are designed using OLE-DB and SQL-Server authentication. At runtime the Crystal Report engine is supplied with SQL-Server user-credentials. To access the RPT file from UNC, the impersonation tag is added in Web.Config.
However the Crystal Report runtime generates the error saying "Failed to open the connection".
I have been reading about issue of 'Double-Hop' while dealing with Crystal Report through ASP.NET.
Any idea about the root cause of problem and possible resolution?