Crystal Reports XI R2 Runtime on Terminal Server Error

[nedder77]

I am working with a friend who is having an error with users on his Terminal Server.

Right now, a user with admin rights can login just fine, and reports which use it run just fine, however when a standard domain user logs in, they get an error while attempting to get a report to run.

I don't have the exact error message available to me at the moment, however I am guessing it is permissions in some way with the terminal server since I can log into another machine with a standard user and there are no problems whatsoever with a report being generated by the Crystal runtime.

I have used the change user /install command while installing the runtime to make sure it gets installed for everyone, but that doesn't appear to be working.

 

[MJRBIM]

It may be a database/ODBC issue at runtime.

What kind of DB do the reports connect to and how...?

Terminal Services doesn't give "standard domain user" access to all the registry stuff for some DBs.

You need to grant explicit permissions for that access.

 

[nedder77]

Well, the report gets created by the server, the error comes when the TS tried to kick up the Runtime in order to parse together the XML generated by the server with the original report.

if I logout and login to the TS as an admin, the report gets pulled up no problem, and that isn't by running the report again, that is by opening the one I just created as a regular user.

The background program running is an epicor vantage server, but that isn't part of the problem, it's the access to the runtime that is causing the issue.

 

[vlepetit]

hi MJRBIM,

i launch my application throught remote desktop on windows 2003 server with classic user account.

when i want to launch a crytal report under my application this error appear :
"error running report. see rpt.log for detail"

and rpt.log :
27/03/2008 16:53:42 ..0.. Crystal job: 0
27/03/2008 16:53:42 ..0.. 512 - The print engine must be open in order for the call to be successful. Your code is lacking a PEOpenEngine call.
27/03/2008 16:53:42 ..0.. Error: Report could not be opened
27/03/2008 16:53:42 ..0.. Error: The database connection was lost. Trying again.
27/03/2008 16:53:42 ..0.. Crystal job: 0
27/03/2008 16:53:42 ..0.. 512 - The print engine must be open in order for the call to be successful. Your code is lacking a PEOpenEngine call.
27/03/2008 16:53:42 ..0.. Error: Report could not be opened
27/03/2008 16:53:42 ..0.. Error: The database connection was lost. Trying again.
27/03/2008 16:53:42 ..0.. Crystal job: 0
27/03/2008 16:53:42 ..0.. 512 - The print engine must be open in order for the call to be successful. Your code is lacking a PEOpenEngine call.
27/03/2008 16:53:42 ..0.. Error: Report could not be opened

but if i do exctly the same with administrator user account all work fine... i can see my reports.

what is the right i forget for my classic users ??

you talk about grant explicit permissions for that access for ODBC. where and how can i do that ?

my db is an access db

thanks

 

[vlepetit]

hi,

i resolve my problem by this procedure describe in my application support :

Details
1. Application on Citrix only works for 1 user

When installing an application like Crystal Reports runtime on a Citrix Server it may result in only the user who installed the application being able to generate a Crystal Report on the Citrix Server.

This is caused by the Windows Installer omitting the ALLUSERS parameter when running the application’s “Setup.exe”, which then does a per-user installation using folders in the user’s personal profile. The result is that the installation only works for that user.

This can be prevented by specifying ALLUSERS=1 as a setup parameter, which then does a per-machine installation using folders in the “All Users” profile. The result is that the installation works for all users on the machine.


2. Use of the ALLUSERS parameter

The /V argument is used to pass command-line switches and values of public properties to Msiexec.exe (The Windows Installer). To install the application for ALL USERS follow the next steps:
1. Use Remote Desktop to make a connection to the Citrix Server and log on as a local Administrator to the machine
2. Click “Start Run, type in CMD and press Enter to open a Command Window
3. Change to the directory in which the application’s SETUP.EXE file resides, which may be on a local/ network drive or CD
4. Type CHANGE USER /INSTALL to put the Citrix Server in “Install mode”
5. Type SETUP.EXE /V”ALLUSERS=1” and press Enter
6. Follow the normal installation steps for the application
7. When the installation is complete, type CHANGE USER /EXECUTE in the Command Window and press Enter to return the Citrix Server to “Execute mode”
8. Close the Command Window and log off the Remote Desktop connection
9. The application should now be accessible to all users of the machine

if this can help anyone, it's cool.

bye