Azure app server connection To azure vm db server intermittently timeout

Question

Azure app server connection To azure vm db server intermittently timeout

Jackstraw91 0

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:

KapilAnanth 49,876 Reputation points Moderator

2024-11-25T12:00:10.38+00:00
@Jackstraw91 ,

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

From your verbatim,

You have a VM in a VNET that runs an application, say ApplicationVM

This is making a call to a VM running SQL, let's call it SqlVM

As next steps,

Can you please specify how exactly are you saying this could be related to Network here.

Did you check the SQL Logs?

Did the request from Application reach the SQL server or is logged in the SQL DB?

The best way to isolate the root cause from Networking side is to collect packet captures at the time of the issue on both ApplicationVM and SqlVM at the time and issue and check whether or not packets reached the SqlVM.

Or this could be related to the application itself as mentioned by Vahid as well

Thanks,

Kapil
Jackstraw91 0 Reputation points

2024-11-26T11:17:20.1433333+00:00

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.
KapilAnanth 49,876 Reputation points Moderator

2024-11-26T13:27:41.0166667+00:00

@Jackstraw91 ,

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
Jackstraw91 0 Reputation points

2024-11-26T13:30:20.99+00:00

yes i understand but i havent the access to do this. Have already requested it from my IT Admins
KapilAnanth 49,876 Reputation points Moderator

2024-11-27T05:36:06.2933333+00:00

@Jackstraw91 sure, let us know how it goes

1 answer

Your answer

KapilAnanth 49,876 Reputation points Moderator

2024-11-25T12:00:10.38+00:00

@Jackstraw91 ,

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

From your verbatim,

You have a VM in a VNET that runs an application, say ApplicationVM

This is making a call to a VM running SQL, let's call it SqlVM

As next steps,

Can you please specify how exactly are you saying this could be related to Network here.

Did you check the SQL Logs?

Did the request from Application reach the SQL server or is logged in the SQL DB?

The best way to isolate the root cause from Networking side is to collect packet captures at the time of the issue on both ApplicationVM and SqlVM at the time and issue and check whether or not packets reached the SqlVM.

Or this could be related to the application itself as mentioned by Vahid as well

Thanks,

Kapil
Jackstraw91 0 Reputation points

2024-11-26T11:17:20.1433333+00:00

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.
KapilAnanth 49,876 Reputation points Moderator

2024-11-26T13:27:41.0166667+00:00

@Jackstraw91 ,

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
Jackstraw91 0 Reputation points

2024-11-26T13:30:20.99+00:00

yes i understand but i havent the access to do this. Have already requested it from my IT Admins
KapilAnanth 49,876 Reputation points Moderator

2024-11-27T05:36:06.2933333+00:00

@Jackstraw91 sure, let us know how it goes

Answer 1

Vahid Ghafarpour 23,605

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/

0 comments

Share via

Azure app server connection To azure vm db server intermittently timeout

1 answer

Your answer