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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.