CRYSTAL REPORT in ASP.NET with UNC and SQL-Server

[Former Member]

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?

[former_member183750 · Accepted solution]

See the following:

http://stackoverflow.com/questions/4334665/steps-to-enable-double-hop-delegation-in-iis7-windows-200...

http://aspalliance.com/532_Understanding_the_Login_Failed_Error_in_Crystal_Reports.4

http://support.microsoft.com/kb/329986

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[former_member11696]

Moved to .NET SDK forum