Crystal Report Prompting for SQL Authentication.

SUGGESTED

Dear Members,

We have recently upgraded the Sage 300 to Sage 300 2022 Premium with product3, after upgrade some of the customized report stop working and is promoting for SQL credentials for all users. some of the customized report getting data through stored procedure and views.

I have already checked with the solution available here.

Even when i am trying to add new master or any table to add extra column, the same thing is happening.

Please suggest some solution if any faced and got the solution for the same.

Thanks

Mohammad Salmani

Parents Reply Children
  • 0 in reply to Shazi

    Dear Shazi,

    I followed the steps mentioned by Zakariyya Carrim and same i have done long back but did not work.

    At the time of verifying the data I am getting the error as screen attached

    In this report I am using DLL of Sage 300 (OEINPR3 and View).

    New connection creating successfully but while verifying database getting the above error.

    Thanks and Regards

    Mohammad Salmani

  • 0 in reply to Mohammad Salmani

    Hi 

    Find KB article content below which can assist in resolving the issue.

    Crystal Reports Error: "Failed to load database information [report name]"

    Summary

    • Displays Error: "Failed to load database information [report name]"
    • Standard Crystal Reports are affected

    Cause

    • Old Crystal report has not been updated for use in current version of Crystal
    • Damaged Crystal Report

    Resolution

    • Uninstall/Reinstall Crystal Runtime Standalone
    • Redesign or update the customized report
    • Restore a copy of the customized report

    The link below could also be tried. 

    www.tek-tips.com/viewthread.cfm