SQL 2008 r2 behind a Cisco ASA5510

Posted on 2012-09-16
Last Modified: 2012-09-19
I need to access a SQL 2008 R2 which is behind a Cisco ASA5510. What ports need to be opened to allow this. I have tried 1433 and 1434 with no luck
Question by:Ron-mds
    LVL 9

    Expert Comment

    if you have a default instance 1433 should be enough.  Make sure you also open the windows firewall port.

    If it is a named instance, then the port is random and you need to configure it to listen on a specific port using this article:

    then make sure that port is open in the router and the windows firewall.

    Author Comment

    Not sure what named instance means but i looked at the configuration for tcp/ip ip1..1p6 and ipall the all say active yes enabled no port 1433. Seems if you connect when on a VPN it will connect but from not on a VPN will no connect
    LVL 25

    Expert Comment

    by:Lee Savidge

    Author Comment

    I will give this a try in the morning... thanks
    LVL 1

    Accepted Solution

    Not only do you need to open up a port inbound on your firewall but you will need a static NAT entry from that port to your server for any data to get through.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now