Help MS SQL PORT FORWARDING

D3V0N

Addict
Joined
Apr 22, 2015
Posts
498
Reaction
446
Age
21
Wazzup mga paps, just wanted to ask if may nakapag try na sa inyo iexpose ang local MS SQL server to the internet. Ang nakikita ko lang kase kay pareng google ay yung allowing remote connection though through the same network lang yung connection dapat. Curious if there is a way to share the connection in the internet. And nakita ko lang is port forwarding though I don't how to set it up. The router that I am using is from PLDT, can that be enough to share my local MS SQL server to the internet? Thanks in advance mga paps!
 
I think you can use XAMPP (or any alternative software) for that.
But before anything else, check if you are on CGNAT or not. Because if you're on CGNAT, port forwarding will not work.
To check, open your modem's gateway (in PLDT's case, then it's 192.168.1.1, then login its credentials), and go to your WAN status, take note of your WAN IP, then go to ipv6-test.c0m. If your WAN IP and your IPv4 address on ipv6-test website are the same, you're not on CGNAT and port forwarding will work. But if it's different (let's say, your WAN IP is 100.x.x.x), then you're probably on CGNAT and any kind of port forwarding will not work.

CGNAT range is from 100.64.0.0 to 100.127.255.255
 
Last edited:

D3V0N

Addict
I think you can use XAMPP (or any alternative software) for that.
But before anything else, check if you are on CGNAT or not. Because if you're on CGNAT, port forwarding will not work.
To check, open your modem's gateway (in PLDT's case, then it's 192.168.1.1, then login its credentials), and go to your WAN status, take note of your WAN IP, then go to ipv6-test.c0m. If your WAN IP and your IPv4 address on ipv6-test website are the same, you're not on CGNAT and port forwarding will work. But if it's different (let's say, your WAN IP is 100.x.x.x), then you're probably on CGNAT and any kind of port forwarding will not work.

CGNAT range is from 100.64.0.0 to 100.127.255.255
Thank you paps! I'll feedback later. Appreciated it!

I think you can use XAMPP (or any alternative software) for that.
But before anything else, check if you are on CGNAT or not. Because if you're on CGNAT, port forwarding will not work.
To check, open your modem's gateway (in PLDT's case, then it's 192.168.1.1, then login its credentials), and go to your WAN status, take note of your WAN IP, then go to ipv6-test.c0m. If your WAN IP and your IPv4 address on ipv6-test website are the same, you're not on CGNAT and port forwarding will work. But if it's different (let's say, your WAN IP is 100.x.x.x), then you're probably on CGNAT and any kind of port forwarding will not work.

CGNAT range is from 100.64.0.0 to 100.127.255.255
FEEDBACK:
My router's WAN IP is 100.71.X.X whilte my IPv4 address is 49.145.X.X
Is port forwarding available for me?
 
Last edited:

D3V0N

Addict
Thank you paps for the response, can I ask another question? I recently check that if I enable UPnP on my router I would be able to use port forwarding. Have you ever tried it? Thanks in advance!
 

dark_cloud

Enthusiast
depende sa router mo, pero most likely posible. ganito setup, yung client ku-kunek sa tcp port 3333 ng modem/router mo. tapos, gawa ka ng rule sa router na for every incoming connection sa WAN Interface tcp port 3333, ibato sa server mo, tcp port 3306.

again, hindi ito safe.
screen02.jpg
 

Attachments

depende sa router mo, pero most likely posible. ganito setup, yung client ku-kunek sa tcp port 3333 ng modem/router mo. tapos, gawa ka ng rule sa router na for every incoming connection sa WAN Interface tcp port 3333, ibato sa server mo, tcp port 3306.

again, hindi ito safe.
View attachment 1780163
Basta may firewall ka, safe ka. Tsaka isang port lang naman yan so hindi siya totally exposed. DMZ ang delikado kasi open lahat ng ports. Di hamak na mas "safe" ang Port forwarding at uPnP kesa sa DMZ, dahil ang port forwarding ay isa-isa mo lang inoopen ang specific port na gagamitin mo, the other ports will remain as closed. Sa uPnP naman, "known ports" lang ang ioopen niyan at maoopen lang ang port na yan pag in-use na, unlike DMZ na whether or not ginagamit mo, lahat ng ports ay naka-open na as default.

Tsaka hindi niya rin magagawa yang tatlo (Port forwarding, uPnP, at DMZ) dahil under siya ng CGNAT.
Kailangan munang itawag niya sa PLDT yan para matanggal ang CGNAT at mabigyan siya ng [dynamic] public IP address (for residential plan) o kaya naman "mag-avail" siya ng static/dedicated IP address niya (enterprise plan).
 
Last edited:

Bagsik2015

Enthusiast
kung gusto mo makapag port fowarding message me, kung ang ONU mo yung 2 antenna papalitan ntin ng 4 antenna iuuncgnat kita at mabibigyan pa kita ng public static ip.
 

dark_cloud

Enthusiast
Basta may firewall ka, safe ka. Tsaka isang port lang naman yan so hindi siya totally exposed. DMZ ang delikado kasi open lahat ng ports. Di hamak na mas "safe" ang Port forwarding at uPnP kesa sa DMZ, dahil ang port forwarding ay isa-isa mo lang inoopen ang specific port na gagamitin mo, the other ports will remain as closed. Sa uPnP naman, "known ports" lang ang ioopen niyan at maoopen lang ang port na yan pag in-use na, unlike DMZ na whether or not ginagamit mo, lahat ng ports ay naka-open na as default.

Tsaka hindi niya rin magagawa yang tatlo (Port forwarding, uPnP, at DMZ) dahil under siya ng CGNAT.
Kailangan munang itawag niya sa PLDT yan para matanggal ang CGNAT at mabigyan siya ng [dynamic] public IP address (for residential plan) o kaya naman "mag-avail" siya ng static/dedicated IP address niya (enterprise plan).
sa mga sinabi mo, isa lang ang tutuo: cgnat.
 
View attachment 1780298
para maniwala ka naka static public ip ako at uncgnat na din at meron akong server na naka port forwarding
residential plan or enterprise (SME/MSME) plan?
Residential plan cannot have "static" public IP, only enterprise plan can, as per PLDT.

View attachment 1780298
para maniwala ka naka static public ip ako at uncgnat na din at meron akong server na naka port forwarding
Oh, it's VLAN-based, so it's not a "static" public IP. Residential plan ka kasi VLAN-based ka eh. Enterprise (SME/MSME) plans are PPPOE-based.
So you do not have a "static" public IP address (as you're claiming). Yes, unCGNAT ka, yes, public IP address ka, but it's not "static", it's "dynamic" for residential plans. (PLDT).

Try mong i-off yang modem mo ng mga 15-30 minutes, then i-on mo ulit (power cycle na tinatawag). Magbabago na ang WAN IP address mo, dahil nga dynamic lang ang pwede sa residential plans.
 
Last edited:

Bagsik2015

Enthusiast
residential plan or enterprise (SME/MSME) plan?
Residential plan cannot have "static" public IP, only enterprise plan can, as per PLDT.


Oh, it's VLAN-based, so it's not a "static" public IP. Residential plan ka kasi VLAN-based ka eh. Enterprise (SME/MSME) plans are PPPOE-based.
So you do not have a "static" public IP address (as you're claiming). Yes, unCGNAT ka, yes, public IP address ka, but it's not "static", it's "dynamic" for residential plans. (PLDT).

Try mong i-off yang modem mo ng mga 15-30 minutes, then i-on mo ulit (power cycle na tinatawag). Magbabago na ang WAN IP address mo, dahil nga dynamic lang ang pwede sa residential plans.
naka ilan try na ako mga off ng ilang minutes :) its all good in the hood subok na subok na
 
naka ilan try na ako mga off ng ilang minutes :) its all good in the hood subok na subok na
Ano plan mo? Kung residential plan ka, dynamic yan, hindi static.

naka ilan try na ako mga off ng ilang minutes :) its all good in the hood subok na subok na
at kelan ka nagpatanggal ng CGNAT? Mula nu'n ba, 112.200.24.50 na ang IP mo? If oo, at hindi pa nagpapalit kahit kelan yang 112.200.24.50, then static ka nga (at malamang enterprise plan ka at may dagdag kang binabayaran sa bill mo)...

Pero malabo yan.... kasi ang VLAN 1039 ay para sa residential plan lang. PPPOE ang mga enterprise/business plan which is sila ang may privilege na "mag-avail" ng static IP (Mag-avail, meaning, may dagdag na add-on fee sa monthly bill nila kasi hindi libre ang static IP, nirerentahan lang ng kahit sino ang static IPv4 address).

Whereas, residential plans can only have dynamic IPs kung nagpatanggal ng CGNAT.
 
Last edited:

dark_cloud

Enthusiast
Better research lods, mukhang namang may alam ka sa networking dahil Cisco ung diagram mo kanina.
For starters, read this You do not have permission to view the full content of this post. Log in or register now.
With that, I rest my case. Up to you to research na lang. Dami ding tuts sa YT.
ano uli yung pinagsasabi mo kanina? DMZ, open lahat ng ports??? DMZ is just a designation for an area. it has nothing to do with ports being open/closed. at yung internal server mo na nasa DMZ needs port forwarding for it to serve its purpose.

sige io-open mo ang upnp sa wan interface and let's see wats gonna hapen :)

kulang ka pa sa pagkakaunawa ng networking...
 
Last edited:

dheluxe

Addict
Lilinawin ko lang TS ah. magkaiba ang MS SQL at My SQL. Kapag my sql madali lang mag port forward. sa ms sql may gagalawin ka pa sa configuration bago port forward.

My Sql sa xampp yan meron. ung MS SQL yan yung sa microsoft. yan ginagmit ko kpag ran private server.
 

D3V0N

Addict
depende sa router mo, pero most likely posible. ganito setup, yung client ku-kunek sa tcp port 3333 ng modem/router mo. tapos, gawa ka ng rule sa router na for every incoming connection sa WAN Interface tcp port 3333, ibato sa server mo, tcp port 3306.

again, hindi ito safe.
View attachment 1780163
Thank you for the info paps!

Basta may firewall ka, safe ka. Tsaka isang port lang naman yan so hindi siya totally exposed. DMZ ang delikado kasi open lahat ng ports. Di hamak na mas "safe" ang Port forwarding at uPnP kesa sa DMZ, dahil ang port forwarding ay isa-isa mo lang inoopen ang specific port na gagamitin mo, the other ports will remain as closed. Sa uPnP naman, "known ports" lang ang ioopen niyan at maoopen lang ang port na yan pag in-use na, unlike DMZ na whether or not ginagamit mo, lahat ng ports ay naka-open na as default.

Tsaka hindi niya rin magagawa yang tatlo (Port forwarding, uPnP, at DMZ) dahil under siya ng CGNAT.
Kailangan munang itawag niya sa PLDT yan para matanggal ang CGNAT at mabigyan siya ng [dynamic] public IP address (for residential plan) o kaya naman "mag-avail" siya ng static/dedicated IP address niya (enterprise plan).
Thank you din po paps, it's more complex than I thought

kung gusto mo makapag port fowarding message me, kung ang ONU mo yung 2 antenna papalitan ntin ng 4 antenna iuuncgnat kita at mabibigyan pa kita ng public static ip.
Thank you for the offer lods, though baka magresearch pa muna ako further about the PLDT plans and port forwarding, etc.

Lilinawin ko lang TS ah. magkaiba ang MS SQL at My SQL. Kapag my sql madali lang mag port forward. sa ms sql may gagalawin ka pa sa configuration bago port forward.

My Sql sa xampp yan meron. ung MS SQL yan yung sa microsoft. yan ginagmit ko kpag ran private server.
Yes paps, aware po ako sa pinagkaiba ng MS SQL and My SQL, mas pabor pa nga po ako sa My SQL unlike MS SQL which is more complicated. Also, I already configured and opened MS SQL server for remote access and listen to port 1433. Thank you paps for the info!

Thank you mga paps! For sharing your knowledge, infos and offers, really appreciated it!
 
residential plan or enterprise (SME/MSME) plan?
Residential plan cannot have "static" public IP, only enterprise plan can, as per PLDT.


Oh, it's VLAN-based, so it's not a "static" public IP. Residential plan ka kasi VLAN-based ka eh. Enterprise (SME/MSME) plans are PPPOE-based.
So you do not have a "static" public IP address (as you're claiming). Yes, unCGNAT ka, yes, public IP address ka, but it's not "static", it's "dynamic" for residential plans. (PLDT).

Try mong i-off yang modem mo ng mga 15-30 minutes, then i-on mo ulit (power cycle na tinatawag). Magbabago na ang WAN IP address mo, dahil nga dynamic lang ang pwede sa residential plans.
Naka static ip po ata siya kung di nagpapalit ang public address niya, pero based sa research ko po is hindi lang po iisa ang gumagamit sa static ip address na meron siya unless kung dedicated ip meron siya. Solong-solo niya at 'yun po ang para sa mga enterprise client ni PLDT na may extra monthly fee ata. Yun lang pagkakaalam ko based sa research ko po. No hates lang mga lods. Share knowledge lang po. Hehehe peace!
 
Top