Is there any way to always assign the same IP address to a VPN client at home? (PPTP, L2TP, or OpenVPN)? We have a database application that only lets specified IP addresses pull data from it.
You can create a VLAN with a new subnet, then make the number of DHCP IPs offered as large (or small) as you require. Assign that VLAN to your incoming VPN service and you’ll know what IPs you need to then set into the database servers permission list.
It’s good practice to have your VPN service on separate VLAN/subnet to other parts of your network, keeping it on a separate VLAN/subnet gives you better options in network security also.
Happy to Help,