Allow access to external SQL server via ODBC thru ISA 2004

Discussion in 'Windows Small Business Server' started by Paul, Dec 13, 2005.

  1. Paul

    Paul Guest

    I am trying to access an external SQL server via ODBC thru ISA 2004. I have
    W2K3 Premium with SP1 and have run CEICW, after that I added the 4 scripts
    from isatools.org dealing with bagle, blaster, mydoom, netsky and sasser so
    they are the top 5 processed rules. Then I created an access rule using the
    SQL protocol (processed 6), allowing the internal network and local host to
    access the external network for that protocol only with, allowed with any
    source port. I still get a denied connection from live monitoring, any idea
    what I need to do at this point? FYI, it works from behind an old linksys FW
    but not behind ISA.

    Thanks for the help.
     
    Paul, Dec 13, 2005
    #1
    1. Advertisements

  2. Paul

    Crina Li Guest

    Hi Paul,

    Thank you for posting in SBS newsgroup.

    From your description, I understand you want to connect to external ODBC
    SQL server though SBS with ISA2004. If I have misunderstood your concerns,
    please do not hesitate to let me know.

    To make the client access normally to external ODBC source, you may need to
    configure a protocol definition and a access rule on ISA. You also need to
    configure the client computer. For detailed information, please refer to
    the following KB article:

    837740 How to configure ISA Server 2004 and SQL Server Enterprise Manager to
    http://support.microsoft.com/?id=837740

    Hope the information help and I look forward to your reply.

    Best regards,

    Crina Li (MSFT)

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    This newsgroup only focuses on SBS technical issues. If you have issues
    regarding other Microsoft products, you'd better post in the corresponding
    newsgroups so that they can be resolved in an efficient and timely manner.
    You can locate the newsgroup here:
    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

    When opening a new thread via the web interface, we recommend you check the
    "Notify me of replies" box to receive e-mail notifications when there are
    any updates in your thread. When responding to posts via your newsreader,
    please "Reply to Group" so that others may learn and benefit from your
    issue.

    Microsoft engineers can only focus on one issue per thread. Although we
    provide other information for your reference, we recommend you post
    different incidents in different threads to keep the thread clean. In doing
    so, it will ensure your issues are resolved in a timely manner.

    For urgent issues, you may want to contact Microsoft CSS directly. Please
    check http://support.microsoft.com for regional support phone numbers.

    Any input or comments in this thread are highly appreciated.

    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------
    | Thread-Topic: Allow access to external SQL server via ODBC thru ISA 2004
    | | From: "=?Utf-8?B?UGF1bA==?=" <>
    | Subject: Allow access to external SQL server via ODBC thru ISA 2004
    | Date: Tue, 13 Dec 2005 14:29:03 -0800
    | | Newsgroups: microsoft.public.windows.server.sbs
    | |
    | I am trying to access an external SQL server via ODBC thru ISA 2004. I
    have
    | W2K3 Premium with SP1 and have run CEICW, after that I added the 4
    scripts
    | from isatools.org dealing with bagle, blaster, mydoom, netsky and sasser
    so
    | they are the top 5 processed rules. Then I created an access rule using
    the
    | SQL protocol (processed 6), allowing the internal network and local host
    to
    | access the external network for that protocol only with, allowed with any
    | source port. I still get a denied connection from live monitoring, any
    idea
    | what I need to do at this point? FYI, it works from behind an old linksys
    FW
    | but not behind ISA.
    |
    | Thanks for the help.
    |
    |
     
    Crina Li, Dec 14, 2005
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.