• Search Forums
    Advanced Search Topics Posts
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
New Member Send Private Message
Posts: 0
New 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 Send Private Message
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
New Member Send Private Message
Posts: 0
New 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.