Link to home
Start Free TrialLog in
Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScFlag for Zambia

asked on

Sql server Network Issues

I want to forward my TCP/IP port 1433 properly to the local workstations, so far I'm now at Enable port forwarding and connect

Steps taken so far

Enable port forwarding and connect

Create a new port forwarding I have noticed that each router is different. But the goal is the same: Enable the Port Forwarding on your router.

To do that, I have done this see below :

– Login to the router
– Search WAN Services
– And create Port forwarding with this informations:
   • Name : Name for this rule (example SQLExpose)
   • Protocole: TCP/UDP
   • WAN port: 1433
   • LAN port: 1433
   • Destination IP:

(1)      On the Destination IP what do I put there??? Is it the host server IP Public address  or Local workstation IP Public Address??????
(2)       At this point since the server is already configured to enable port 1433 can the machines on LAN work??
(3)      What about those on a secure network (VPN) as per above setting can the machines work?

See picture also

User generated image

This is one of the toughest area I’m encountering so far, they are just too many rules, anyway further advice or notes will be appreciated it’s a learning curve.

Regards

Chris
ASKER CERTIFIED SOLUTION
Avatar of noci
noci

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial