Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Port forwarding on router

Posted on 2014-01-27
13
Medium Priority
?
323 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

At the beginning of the year, the IT world was taken hostage by the shareholders of LogMeIn. Their free product, which had been free for ten years, all of the sudden became a "pay" product. Now, I am the first person who will say that software maker…
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
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…

916 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