At my company we currently are using the Quickbooks Desktop edition and its using Quickbooks Database Server manager to host a Multi-User Mode solution for our network. Normally we are able to have multiple users access the same Company file at the same time on the same local network.
After some time there is now remote user that dials in using RRAS L2TP VPN on Windows Server 2019 (Same machine with Quickbooks Database Server). It is configured with a static IP pool for the last 10 IP's on the subnet. This VPN user can access the company just fine via a Windows Share from the server. The problem occurs when a VPN client is "Logged In" to a Quickbooks Company file, and a local office user tries to connect to the same file. It does not let them open the same Company file with an error message, and is behaving as a first come first serve scenario when users attempt to open it.
After some IT diagnostics, I noticed the VPN IP pool from the server has heavy firewall applied to all inbound traffic to a VPN client's local IP. I'm assuming this is the issue when a VPN client and Local client try to connect to the same company file. If this observation of mine sounds to be the case, how would I change these firewall rules?
If it seems to be another issue, may I receive guidance?