Rights to load data into Crystal Report...

Hi everybody,

When I place data field into crystal report and then run the web application, it causes
error with a message:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.

What are the rights necessary for what accounts on db server, IUSR and ASPNet account, and others

I am using a Domain Account to access local pc and the web application is local pc. But the sql databases server is located on another pcs.

Tell me what to do.

Thanks.

den2005



Answer this question

Rights to load data into Crystal Report...

  • stfn

    This problem has been resolved.

    Solution:

    GUI dataset is used creating crystal report.

    Hope this helps someone in the future...

    den2005


  • Johannes Hofmann

    You get this logon failed because Crystal needs to logon to your sql server to retrieve data. This can be done by using the report Document object model and using the SetDatabaseLogon("username", "password") method. This allows Crystal to connect to your database. It does not store the user name and password in the report file for security reasons.
  • kiwilad66

    Hi mewdied,

    How exactly to do that Is this because I am using a domain account I created crystal report but using local pc account and has no problems with "Logon Failed" error before.

    Thanks for replying.

    den2005


  • blitz_krieg

    Hi,
       There is no "SetDatabaseLogon" in ReportDocument class of VS 2002. What else can be done for this problem

    den2005

  • Rights to load data into Crystal Report...