Windows 7 SQL application link disconnect

[geo77]

Hi,
I am beginning to feel lost and I need some help because I need to fix this problem I've been having at work.

Basically, I have been having issues with my network drives, seems like after a certain amount of time computers are not able to see my other computers in the same workgroup, and the most important one the company server. As a result, networks drives are not found, as well as having reliability issues with a sql driven program that uses sql native drivers, this is the most pervasive and important of the two.

Here are the things I've tried not sure what order or combination.

disabled firewall in server and client
disabled antivirus
added a wins server to the mix hoping it would help the problem, didn't work
added entries to the host files of the workstations pointing to the server, no good either.
bought a new main switch, nothing
both wired and wireless devices are experiencing the same issue
Weirder still is that I set an endless ping and the problem occurs to a lesser extent, but still happens.

Attached a wireshark dump for the application connection.
192.168.1.110 is the server.
Any help is greatly appreciated, not sure what other things to do to get this fixed.

 

[ChatGPT]

It seems like the network connectivity between your workstations and the server is intermittent, leading to issues with network drives and the SQL-driven program. To troubleshoot and fix this problem, you can try the following steps:

Troubleshooting Suggestions:​

1. Check Network Configuration:
   • Verify that all devices are on the same subnet and are configured with the correct IP addresses, subnet masks, and default gateway.
   []Network Equipment:
   • Ensure there are no issues with the network equipment (switches, routers, etc.). Check for any errors or unusual activity on the network devices.
   []DNS Configuration:
   • Confirm the DNS settings on all devices, ensuring they point to the correct DNS server. Clear the DNS cache if needed.
   []Wireshark Analysis:
   • Analyze the Wireshark dump to identify any anomalies or errors in the network traffic that could be causing the connectivity issues.
   []Network Stability:
   • Test network stability by running continuous ping tests from various devices to the server. Monitor for any packet loss or irregularities.
   []Check Firewall Configuration:
   • Re-enable the firewall and antivirus temporarily and ensure they are correctly configured to allow traffic between devices on the network.
   []Check Antivirus Settings:
   • Some antivirus software can interfere with network connectivity. Review antivirus settings and temporarily disable or whitelist network traffic for testing.
   []Update Network Drivers:
   • Ensure all network drivers on the workstations and the server are up to date. Outdated drivers can lead to network connectivity issues.
   []Test Connectivity:
   • Test connectivity by trying to access network resources (shared folders, network drives) from different devices to see if the issue persists across all devices.
2. Consult IT Support:
   • If the issue persists, consider involving IT support or network professionals to perform a detailed network analysis and provide further guidance.

     Additional Information Needed:​

     • It might help to know the exact error messages or symptoms experienced when trying to access network resources.
     • Detailed network configuration information, including IP addressing scheme, subnet mask, default gateway, and DNS server settings.
     By following these troubleshooting steps and gathering more specific information, you should be able to identify and resolve the network connectivity issues impacting your network drives and the SQL-driven program.