Please help how to configure with NAT setup this diagram… please…
MSSQL server
sql5014.site4now.net
208.118.63.129
port 1433
Mikrotik Firewall /NAT
210.4.103.116
port 80
192.168.1.50
PC
192.168.1.41
Message: unable to remote desktop from sql5014.site4now.net
Which remote desktop client are you using? Microsoft RDP client, VNC, …?
On which host are you running the remote desktop client? PC?
We are using Visual Studio 2013… remoting sqlserver…
I still don’t get it … so you have LAN with a PC on which you’re running VS2013. That LAN has a RB as gateway/firewall (with NAT for port 80 which doesn’t seem to me as relevant in this particular scenario) … and thee’s a MSSQL server somewhere on the internet accepting connections on port 1433?
If my understanding is right and the RB config is more or less default (allowing any kind of LAN-to-WAN connections), then it should work as is if remote side doesn’t block connections …
Newbie here… sorry for that… our LAN is filtered… and allow only port 80 at the moment… as we follow the NAT configuration… and successfully it works…
and here comes our project…online website… unfortunately my PC can’t access the sql server outside our network… but local sqlservers…within our network… it allows…
in view of this… we do direct… connection… meaning… no filtered… directly or… shall I say… i used the registered address… and it works… to remote the outside sqlserver…
thats our problem… we dont know how to configure… our Mikrotik Router to allow remote connection from Local PC inside to outside SQlServer which has open port of 1433…
i wonder why… may be it be coz were allowed to use only for 80… within our LAN?!?