can't connect to a sql database from an ISA server

Posted on 2009-12-17
Last Modified: 2012-05-08
I am testing some reporting software (GFI Webmonitor) on an ISA 2004 server and I have created a new database on our sql server but for some reason I cannot connect to it.  I can connect to the sql server from any other computer, just not the ISA 2004 server.  I created a rule but that didn't make any difference.
Question by:gilmanschool
    LVL 57

    Expert Comment

    by:Raja Jegan R
    Kindly post the error you encounter to help you out better..

    Also kindly confirm / let me know

    1. How you try to connect to that database either using SSMS or the application
    2. Check the credentials that are used to connect the database..
    LVL 4

    Expert Comment

    What connection type you have used to connect to the database?

    Author Comment

    I'm just trying to telnet to it on port 1433.   Not using any credentials at that point.   When done from any other machine that isn't an ISA server I get a black screen which the software tech people tell me is what you're supposed to get.  From an ISA server I get:

    C:\Documents and Settings\Administrator.GILNET>telnet millennium 1433
    Connecting To millennium...Could not open connection to the host, on port 1433:
    Connect failed
    LVL 27

    Expert Comment

    by:Jason Watkins
    I am 99.9% sure that the telnet protocol is not sanctioned on the ISA server.  Enable telnet and it's associated port (23) on the ISA server's exception list.

    Accepted Solution

    The original ISA rule i created wasn't 100% correct.    I had the rule allowing traffic to the sql database server specifically.  When I changed it to "internal" it worked.

    Expert Comment

    Hi, Can you tell me what the ISA rule you created was please?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Learn about cloud computing and its benefits for small business owners.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    737 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

    17 Experts available now in Live!

    Get 1:1 Help Now