asked on

Crystal Reports Server 11 -- Error Failed to open the connection *.rpt

When publishing any report to Crystal Reports Server (11) and running the report via Infoview......if the report has a PARAMETER the following message is received "Failed to open the connection" (*.rpt). If the report's parameter is removed the report runs fine. These reports have been tested with the Administrator user and a test user ID. I have patched the server with the most recent CR Server 11 service pack and hot fixes. These reports run with and without the parameter on a standalone version of CR 11 which resides on my workstation and a standalone version of CR 11 which resides on the server. I have spent about 6 hours on the phone with Business Objects without resolution. Help please!

ASKER CERTIFIED SOLUTION

wykabryan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cindyfwills

ASKER

Thank you for your suggestions. The cacheserver process and two other processes were changed from local server administrator to domain server administrator and these parameter reports are now working! I believe it must be the way these processes interact with the GUPTA SQL ODBC driver.

Mike McCracken

Do you still need assistance?

mlmcc

cindyfwills

ASKER

No, my issue has been resolved -- thank you!

cindyfwills

ASKER

I awarded the points -- thank you -- please close

netfreak99

Hi cindyfwills,

I am having the same problem. Everything is running OK on my Windows XP machine. I then put these reports onto my Windows 2003 Enterprise Server and the reports come up with the same error: Failed to open the connection.

Could you please elaborate on how did you resolve this issue?

Thanks,
Irfan.