Last post Sep 07, 2012 05:51 AM by necro_mancer
Aug 30, 2012 09:34 AM|yogeshb|LINK
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 (However no luck in figuring it out)
Any idea about the root cause of problem and possible resolution?
Sep 03, 2012 04:05 AM|Ajay2707|LINK
First check that your local sql management studio connect the sqlserver. Also check server connection proerties i.e. Named Pipes or
see all link, may be help you.
Sep 07, 2012 05:51 AM|necro_mancer|LINK
The "failed to open the connection" error message simply means that:
1. Your SQL Server is not found
2. Your SQL Server port is closed
Above all, this is the issue with your connection string. May I please know how did you host this Crystal Report? Do you run your own server or do you host it with a hosting provider? If you run your own server, you need to make sure you can connect to your
SQL Server first via SQL Mgmt Studio tool. If you can connect, you just need to use exactly the same settings on your connection string
If you host it with a hosting provider, you need to contact them to find the correct connection string.
Please mark this response as an "answer" if it helps you. Thanks heaps!