We have two programs that we want to give remote users access to. Both programs are on a server inside our firewall in our building. Both programs have Access as a front end and SQL as the backend.
The question are (and I hope I ask them correctly, this is WAY out of my area of knowledge), I want to punch holes in the firewall for specific IP addresses (our users) and only open port 1433. Is this a viable idea?, Is this a huge security issue (I am under the impression that if you tell the firewall to only accept from specific IPs it is more secure, plus we are only opening port 1433)? Would we be better off putting the backends on Azure and just replicating the info from our server to Azure?
Any info is greatly appreciated!