Solved

Port forwarding on router

Posted on 2014-01-27
13
316 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Like many organizations, your foray into cloud computing may have started with an ancillary or security service, like email spam and virus protection. For some, the first or second step into the cloud was moving email off-premise. For others, a clou…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
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…

791 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