Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Port forwarding on router

Posted on 2014-01-27
13
Medium Priority
?
321 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
Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

 
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
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…

722 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