right now im a having a problem and i have reduced the problem to my mikrotik or my ISP.
so i have a server virtualized outside my LAN lets say 190.90.1.20 this server has MS SQL SERVER and i have MS SQL SERVER in a computer on my LAN lets say 10.10.11.11, i have a mikrotik ISP provided doing nothing but bridge (can see inside ISP policy) then i have my mikrotik with public IP lets say 190.90.90.90 now the thing is the MS SQL in my network cant reach the MS SQL in the cloud server.
right now my mikrotik only has some NAT to redirect trafic from some publics IP to several of our servers.
can you ping the virtualized server outside your lan?
can you connect to it some other way (ssh, http etc)?
besides nat rules do you have any other rules?
check if the ms sql server is visible from the internet http://www.yougetsignal.com/tools/open-ports/ (from what i saw on the web the port is by default 1433).
Are you able to ping the server?
An ISP may block MS SQL packets to avoid attacks and worms.
You may need to setup a VPN.
I cant ping the server, but i know thats becasue of the server firewall, if i turn the firewall i can reach it with a ping, but i dont want to reach it by ping if i can use remote desktop server.
BUT i just tested connecting a cable directly to my ISP mikrotik and configuring manually one of my public ip’s and now i can connect but if i do this in my switch i can’t is there anything i have to enable in mikrotik to let any trafick to my remote server pass.
i created a firewall rule to accept input and output from my remote server.
Use the forward chain for devices communicating THROUGH the Mikrotik.
Input and Output govern communication with the router itself.
isn’t that to accept traffic IN? i need to let the traffic to an specific server in the port 1433 out.