Hello Michael Storry
I understand that you are experiencing a connectivity timeout issue when attempting to connect your App server to your Database server, even though the NSG rules seem properly configured and there are no Windows Firewall blocks on the traffic.
Here are a few things you can check:
- Although you mentioned that the NSG rules seem correct, double-check if there are any NSG rules on VM NIC or Subnet level that might be blocking specific ports or IP ranges. So, please make sure that the rules are set to allow incoming and outgoing traffic specifically for the ports being used by your applications.
- Use connection troubleshoot and test the traffic from App server in subnet A to a database server in Subnet B and check for the reasons.
- If you’re using any virtual appliances or additional routing mechanisms (like UDRs), ensure that they’re not affecting the connectivity. Check if the routing is correct and that no extra elements are blocking or redirecting traffic incorrectly.
- If you're using hostnames instead of IP addresses, it's possible that DNS resolution could be causing the timeout. Verify that your servers can resolve the necessary names correctly.
- Ensure the connection string used in the App server is accurate and that it specifies the right credentials, server name, port number, etc.
Since you mentioned that the MGMT server in subnet C can connect to the Database server without issues, it might be helpful to check if there are any differences in configuration, such as security policies or environment variables, between the App server and the MGMT server.
If still issue persists, please share the below details over private messages for further troubleshooting.
- What is the source and destination Ips/VNets for both working and non-working scenarios?
- What ports are being used for the connection between the App server and the Database server?
- Have you checked for any additional firewalls or security appliances in your network path
- Please share the screenshots of NIC effective routes of app and database server.
- Are both servers within the same VNET or different VNets? If they are in different VNets, please make sure VNets are peered.
- Have you tried accessing the Database server from the App server using its IP address or its hostname? and please share the ping or Test-Net Connection results?
- Are there any application-specific logs on the App server that indicate more information about the timeout?
Please add a comment below if you have any further questions.
If the above information was helpful. Please click "Accept" the answer as original posters help the community find answers faster by identifying the correct answer.