Symptom
When a Crystal Report is published to the Crystal Reports Server and previewed, the following error is displayed: "Database logon information is either missing or incorrect".
Environment
- Crystal Reports XI R2
- Crystal Reports Server XI R2 SP2
Reproducing the Issue
- Create a report in Crystal Reports XI R2 based off the Oracle database.
- Save the report to the Crystal Reports Server XI R2 SP2.
- Logon to Central Management Console (CMC) using the Administration Launchpad.
- Open the report just saved in the Crystal Reports Server.
- Click on the ‘Preview’ button on the ‘Properties’ tab of the report.
- "Database logon information is either missing or incorrect" error is returned.
Cause
The user account used to logon to the Oracle database server does not have the administrative privileges.
Resolution
- Create a report in Crystal Reports XI R2 based off the Oracle database.
- Save the report in Crystal Reports Server XI R2 SP2.
- Logon to Central Management Console (CMC) using the Administration Launchpad.
- Open the report just saved in Crystal Reports Server.
- Click ‘Process’ tab of the report.
- Click ‘Database’ tab under ‘Process’ tab.
- Click "Use custom database logon information specified here" option.
- Select ‘Oracle’ under the ‘Select a database driver’ option.
- Enter the "tnsname" of the Oracle database server in the textbox for ‘Server’.
- Leave the textbox for ‘Database’ blank.
- Enter the Oracle database Server's username in the textbox for ‘User’.
- This username should have all the Administrative Privileges.
- Enter the password in the ‘Password’ textbox.
- Click ‘Use same database logon as when report is run’ under ‘When viewing report:’
- Click the ‘Update’ button.
- Click ‘Properties’.
- Click ‘Preview’.
See Also
Article from Oracle that guides how to configure Crystal Reports Server for Oracle is
Keywords
Database logon information, missing or incorrect , KBA , BI-RA , Reporting, analysis, and dashboards , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem
Product
SAP Crystal Reports XI R2