Crystal REports Viewer Problem

[CrystalUser1]

I have a problem in accessing my report through asp.

WE are usin Crystal 8.5. I amnot sure what are all using because i am new here.

When I run the report through application, I am getting the following error:

Crystal report Viewer: Cannot Open Sql Server. [On CAche/Page Server: ServerName.PageServer].

Can anybody please tell me what could be causing this error. I could run the other reports without any problem.

Thanks

 

[BoniR]

Hello,

The reports are probably using a trusted connection to the database. The Crystal Page Server and Crystal Report Job Server, are configured, by default, to use the System account for the services. The System account cannot be validated for a trusted connection.

Therefore, it is necessary to change the account used by the services to a valid domain user account that could successfully make a trusted connection to the database. This will allow viewing to function as expected.

Hope this helps!
Boni



Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269