Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

error trying to resource data on a Crystal report

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
drhoades44
Advanced Member
Posts: 46
Advanced Member
10/26/2009 3:58 PM

    ado error code 0x80004005 cannot open database requested

    I have a Crystal report that uses a SQL Server stored procedure as the data source. We have modified the stored proc at times, I've changed the data source on the report and sent it for republishing. Somehow, last week, this all changed and I can no longer change the data source on the report. We checked and I do have EXEC permissions but I still get the error. I have uninstalled and reinstalled Crystal. We are on 8.1 (upgrade not complete yet to 9.x).

    Database Connector Error: "ado Error Code: x80040e09

    Source: Microsoft OLE DB PRovider for SQL Server

    Description: EXECUTE permission denied on object 'TransHistoryAccount20091016_pr',database 'prod', ownder 'dob'.

    SQL State: 42000

    Native Error: 229 [Dataabase Vendor Code: 229]'

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    10/26/2009 5:42 PM
      drhoades44: Are you getting this from within LBI, or just within Crystal?

      Check the LBI and/RAS servers for the user that has started server1, and Report Application Server services. This login needs execute permissions as well.
      drhoades44
      Advanced Member
      Posts: 46
      Advanced Member
      10/28/2009 1:21 PM
        Lawson returned my call and gave some pointed questions that I sent to the sys admin. Resetting the privs fixed the issue. Thanks for the input.