Instructions to Unblock Firewall for Administrator

Posted on 2007-10-06
Last Modified: 2012-05-05
If my VB6 program requires access to an SQL database through port 1433, then my guess is that I need to have port 1433 opened at every site my program is used...correct?   If the port is blocked, what instructions should I give the network administrator?
Question by:al4629740
    LVL 5

    Accepted Solution

    Most software firewalls on the pc will ask the user for permission to allow the outbound connection, and learn from that.

    If there is a firewall protecting the SQL server, the Admin will need to open that for the user. That would have to be put in a System Requirements section in the documentation you provide them. If they are running a SQL server, they usually are aware of the requirements for network access.

    Be aware that not ALL SQL servers are listening on that port. That is the default, but since there are worms that scan for that open port, some admins will use a different port.

    Unless YOU are installing the SQL server AND app in the same machine, then it's a different kettle of fish! :)

    Hope that helps a little....
    LVL 51

    Expert Comment

    > .. what instructions should I give the network administrator?
    allow TCP on port 1433 in- and outbound, at least initiated from outbound (assuming that the SQL server is inbound)

    But I'd never open that port (see previous comment:)

    Author Comment

    What is a good port range to open?
    LVL 51

    Expert Comment

    depends ..
    I'd open only the necessary ports, for web it is 80 and 443, usually.

    Author Comment

    But I need to have another port for my application.
    LVL 5

    Expert Comment

    You can pick just about anything that is not in common use (anything below 1024 is considered "common") but it also depends on what is in use already. If you app really needs network access to a SQL server, just pick a port that is not already used. You can Google a list of common ports.

    Better may be to provide a way for the CLIENT to specify what port to use in an options dialog, so each client can specify what THEY actually use. Set the default as the default 1433, but give each individual install a way to change the port to match what they NEED.

    You will never be able to pick a port that is perfect for everybody.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    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.
    As companies replace their old PBX phone systems with Unified IP Communications, many are finding out that legacy applications such as fax do not work well with VoIP. Fortunately, Cloud Faxing provides a cost-effective alternative that works over an…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    758 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

    12 Experts available now in Live!

    Get 1:1 Help Now