crystal report failing with incorrect log on parameters.

[former_member418791]

I have 3 crystal reports failing with below error.I have checked the database credentials by logging in to db,i am able to execute the query.

I have created the odbc connection as well,but no luck.

Error in File XXXXX.rpt: Unable to connect: incorrect log on parameters.

Thanks,

Vikram

[arthurbagumyan]

Hi,

I have seen comments saying to connect to CMC however, I inquired within my company and we do not have a crystal reports dedicated server. We have reports that are used with Sage X3. I have found that a number of these reports were ported from v6 to v8 then to v12 of Sage X3 and when modifying or trying to add a new table etc I can link a new data source but I am encountering this same error. *some reports work but im coming across a few that will not after a table is added for instance. So how can I access CMC ? Below is the version info I have. Any advice would be helpful.

[former_member316829]

If you check your Crystal report "Database configuration" by right click on the report in CMC, you will find that the option that is selected by default is "Use SSO context for database logon (viewing only)" which seems to be causing this issue. To solve this

1. Logon to the CMC
2. Navigate to Applications and double-click the Crystal Reports Configuration
3. Select the Signle Sign-On Options and remove the driver being used by the report (eg crdb_bwmdx,..)
4. Restart the Crystal reports Services
5. The database logon options are no longer grayed out
6. After which you can select “Prompt the User for DB logon” under "Database configuration" for Crystal report

Once this is done you can try to run the crystal report and check if you are getting the same error.

Thanks,

Deepak