Skip to Content
avatar image
Former Member

crystal report failing with incorrect log on parameters.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded