Port forwarding on router

Hi,
I am trying to access the sql 2008 server installed on a windows 2008 server, using an application. The windows 2008 server machine has a static IP, and I am able to access when I used the DMZ on the router, but I heard that it is not that much secure way to access the server DMZ, so I have decided to access it using port forwarding, which is very new to me. So please could you help me how to do that. I have attached the screen shot how i did port forwarding, but it is not working out for me.

Thanks in advance.
PortForwarding.jpg
CPSRIAsked:
Who is Participating?
 
CPSRIConnect With a Mentor Author Commented:
i am continuing with DMZ ..
0
 
CPSRIAuthor Commented:
Sorry, I have missed that I am trying to access from an external network.
0
 
Fred MarshallPrincipalCommented:
The incoming port numbers and the target port numbers need not be the same - although it's OK to do it that way.  The question is: are they correct?  Is the server IP address indeed 192.168.1.10?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
CPSRIAuthor Commented:
yes the server IP is 192.168.1.10, but I am not sure about the port. How can I know that which port does sql use on my server? And one more thing is how should I mention the ip address in the application from external network? I did like this xxx.xxx.xx.xx:1434 (i used here the static ip), am i correct?
0
 
MiftaulCommented:
Here is the instruction on how to identify SQL server ports in use - Link
0
 
CPSRIAuthor Commented:
Thank You for your comment, but the values that the link shown and the values that I have on my server are different, I have attached the both of them, please check and help me.
I-have.jpg
WebsiteShown.png
0
 
MiftaulCommented:
The port can be different. Your SQL database engine uses port TCP 1433
0
 
CPSRIAuthor Commented:
ok, could you please help me to forward the port on my router? I have attached the screen shot how i did that in my first post.
0
 
CPSRIAuthor Commented:
please help...
0
 
Fred MarshallPrincipalCommented:
Perhaps the issue is that the external access isn't doing what you expect/assume?
That is, one can imagine a web page that accesses the database.
The web page launches packets destined for the IP address and a port.
You need to know what that port is.
At the moment, I'm not sure how to tell you how to figure that out.

For example, the external access might be pointing to port 999.  And you want it to access port 1433.
In that case you want the WAN port to be 999 and the LAN port to be 1433.
0
 
CPSRIAuthor Commented:
its an application that has to access the sql database from external network. At this moment my question is, to which port that the application needed to be pointed to access the sql database which is on port 1433? I mean what will be the WAN port, how can i know that? please help...
0
 
Fred MarshallPrincipalCommented:
Yes, it's an application that has to access the sql database from an external network.\

The question is: WHICH APPLICATION is it and which port does it use / assume to access the sql database.  Only you know that at present until you provide more information.
0
 
CPSRIAuthor Commented:
I didn't get answer,,
0
All Courses

From novice to tech pro — start learning today.