Solved

Port forwarding on router

Posted on 2014-01-27
13
317 Views
Last Modified: 2014-05-28
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
0
Comment
Question by:CPSRI
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
  • 2
13 Comments
 

Author Comment

by:CPSRI
ID: 39814198
Sorry, I have missed that I am trying to access from an external network.
0
 
LVL 26

Expert Comment

by:Fred Marshall
ID: 39814248
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
 

Author Comment

by:CPSRI
ID: 39814318
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
Don't miss ATEN at NAB Show April 24-27!

Visit ATEN at NAB Show to learn how our "Seamlessly Entertaining" solutions deliver fast, precise video streaming without delays for the broadcasting and media environment. ATEN will showcase its 16x16 Modular Matrix Switch (VM1600) and KVM Over IP Solution (KE6900 series).

 
LVL 11

Expert Comment

by:Miftaul
ID: 39815109
Here is the instruction on how to identify SQL server ports in use - Link
0
 

Author Comment

by:CPSRI
ID: 39815444
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
 
LVL 11

Expert Comment

by:Miftaul
ID: 39815579
The port can be different. Your SQL database engine uses port TCP 1433
0
 

Author Comment

by:CPSRI
ID: 39816844
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
 

Author Comment

by:CPSRI
ID: 39820008
please help...
0
 
LVL 26

Expert Comment

by:Fred Marshall
ID: 39821626
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
 

Author Comment

by:CPSRI
ID: 39821732
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
 
LVL 26

Expert Comment

by:Fred Marshall
ID: 39823213
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
 

Accepted Solution

by:
CPSRI earned 0 total points
ID: 40086047
i am continuing with DMZ ..
0
 

Author Closing Comment

by:CPSRI
ID: 40095113
I didn't get answer,,
0

Featured Post

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quality of Service (QoS) options are nearly endless when it comes to networks today. This article is merely one example of how it can be handled in a hub-n-spoke design using a 3-tier configuration.
I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question