Skip to Content
0

crystal report failing with incorrect log on parameters.

Apr 13, 2017 at 04:22 PM

81

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 14, 2017 at 09:30 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded