Solved

SQL server behind cisco router, what ports needs to be open?

Posted on 2010-11-30
2
1,570 Views
Last Modified: 2012-05-10
I have Microsoft SQL Express server (IP 10.10.12.51) behind CISCO router and I have no idea why port 1433 or 1434 is not open for outside connections. Here you have a part of the Router cisco 1841 Ver 12.4(13r)  config:

 permit tcp any host xx.xx.xx.xx established
 permit tcp any host xx.xx.xx.xx eq 80 log
 permit tcp any host xx.xx.xx.xx eq 1433 log
 permit tcp any host xx.xx.xx.xx eq 1434 log

where xx.xx.xx.xx is my External IP , strange part is to test it i remove all 3 lines and can't access to my web server, but if put the line " permit tcp any host xx.xx.xx.xx eq 80 log" it worked my web server.(with that test i know that i'm in the correct direction.
is there any other port that needs to be open? or any other line for the cisco router

i tried "telnet xx.xx.xx.xx 1433  getting the "could not open connection to the host, on port 1433: connect failed"

my server is a windows 2003 web server , firewall is off.
0
Comment
Question by:juanchisv
2 Comments
 
LVL 13

Accepted Solution

by:
SIM50 earned 500 total points
ID: 34240232
I think MS SQL Express is a named instance by the default. Named instances have dynamic port assignments. Only default instances in MS SQL assigned port 1433. You need to manually assign a static port in SQL server configuration or the next time you will restart the server, it will get a new port number and it will be blocked again.
0
 

Author Closing Comment

by:juanchisv
ID: 34258427
thank you.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

New Server 172.16.200.2  was moved from behind Router R2 f0/1 to behind router R1 int f/01 and has now address 172.16.100.2. But we want users still to be able to connected to it by old IP. How to do it ? We can used destination NAT (DNAT).  In DNAT…
I recently attended Cisco Live! in Las Vegas, a conference that boasted over 28,000 techies in attendance, and a week of hands-on learning hosted by a solid partner with which Concerto goes to market.  Every year, Cisco displays cutting-edge technol…
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…

948 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now