This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
we have an app with built in crystal reports and they have saved connection details in the reports. When we click the button to generate, it often works. Every once in a while it will fail and give us "database login failed" which i believe is a timeout because it takes a few seconds to try and load before returning the error. On the server we get the below application warning. Any ideas how to resolve this? we have dev and qa which never have this issue, only production and it is still in the staging stage right now, has not gone live so not too many users yet.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/22/2024 5:39:23 AM
Event time (UTC): 11/22/2024 1:39:23 PM
Event ID: 29920c061bfc46658acb83ed590227c5
Event sequence: 7709
Event occurrence: 6
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/DM-7-133766962874903090
Trust level: Full
Application Virtual Path: /DM
Application Path: C:\Inetpub\wwwroot\DM\
Machine name:
Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
From your verbatim,
As next steps,
Thanks,
Kapil
Thanks for your responses. I do believer this is the network issue, as i am not seeing it on the sql logs when the fail occurs.
This is not the correct approach.
I would suggest you collect packet captures simultaneously at the source and destination at the time of the issue to see whether or not if the packet was received by the SqlVM.
Cheers,
Kapil
yes i understand but i havent the access to do this. Have already requested it from my IT Admins
@Jackstraw91 sure, let us know how it goes
Ensure that the ODBC Data Source Name (DSN) used in the report exists on the server and is correctly configured. Verify that it matches the bitness (32-bit or 64-bit) of the Crystal Reports application.
https://remiware.co/2016/09/28/how-to-fix-database-logon-failed-in-crystal-reports/