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!
Who is Participating?
wykabryanConnect With a Mentor Commented:
are you filling in the parameter with information?  Do you have the defaults set correctly in the CMC, under objects>Process>Parameters? Make sure that if you are using a database connection (not a business view or universe) that you have the option called" When viewing reports" turned to Use same database logon as when report is run.

Outside of that I am out of ideas.
cindyfwillsAuthor Commented:
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.
Do you still need assistance?

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

cindyfwillsAuthor Commented:
No, my issue has been resolved -- thank you!
cindyfwillsAuthor Commented:
I awarded the points -- thank you -- please close
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?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.