We are running an SQL server in our office, every user is running a custom software that is fed by the SQL.
We have a firewall on our server, with IP addresses allowed for remote access using the custom software.
However, as you all would know if IP address changes, we lose access, until someone calls in with IP address so we can add to safe list, and manually remove the old IP address, but this is not an option during off-hours.
Adding IP range would be too risky. Having individual users run a gotomyPC or VNC would be a training nightmare as some of the users have no clue about operation of firewall or remote connection. (Not only they need to be trained on remote connection, but we would also have to allow them to modify firewall settings & access our server as administration)
I thought about MAC address related blocking/safe-list, but I assume that's not really an option.
Are there any firewalls (soft or hardware) that uses secure encrypted certificates on each workstation/laptop to allow remote access?
Or firewall that has small remote clients that continuously running on windows allowing firewall to let them in the network?
Question
hyde+
We are running an SQL server in our office, every user is running a custom software that is fed by the SQL.
We have a firewall on our server, with IP addresses allowed for remote access using the custom software.
However, as you all would know if IP address changes, we lose access, until someone calls in with IP address so we can add to safe list, and manually remove the old IP address, but this is not an option during off-hours.
Adding IP range would be too risky. Having individual users run a gotomyPC or VNC would be a training nightmare as some of the users have no clue about operation of firewall or remote connection. (Not only they need to be trained on remote connection, but we would also have to allow them to modify firewall settings & access our server as administration)
I thought about MAC address related blocking/safe-list, but I assume that's not really an option.
Are there any firewalls (soft or hardware) that uses secure encrypted certificates on each workstation/laptop to allow remote access?
Or firewall that has small remote clients that continuously running on windows allowing firewall to let them in the network?
Any suggestions are highly appreciated.
Link to comment
Share on other sites
13 answers to this question
Recommended Posts