• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1687
  • Last Modified:

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

I have Microsoft SQL Express server (IP 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.
1 Solution
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.
juanchisvAuthor Commented:
thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now