Access MS SQL through ISA Server 2004

Posted on 2006-04-15
Last Modified: 2008-11-18
Hi experts, I'd appreciate any assistance with the following please!

I have a server that has ISA Server 2004 set up on it, and also MS SQL 2000.  When creating an ODBC connection on the server to MS SQL it connects fine, however any internal computers cannot connect to SQL Server - I just get the following error:

Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

So far I have done the following to try and get this working:

1) Followed the steps highlighted in

2) Logged all traffic in ISA Server, and it picks up that the client's trying to connect to SQL Server, but nothing is coming up as "Denied"

3) SQL Server is setup to allow "SQL Server and Windows" authentication

4) In SQL Server properties, "TCP/IP" is in the "Enabled Protocols" list set to port 1433

5) When creating an ODBC connection I have tried connecting with Windows Authentication and the System Administrator login details

6) Also when creating the ODBC connection I have unselected the "Dynamically determine port" option and set the port to 1433.

What obvious thing am I doing wrong?

Many thanks!

Question by:danielgallo
    LVL 51

    Expert Comment

    by:Keith Alabaster
    What are you trying to achieve? Publish the sql server to the outside or use it for your internal users?
    What ports have you forwarded from your external firewall/router to the ISA server external interface? (If its to the outside world)
    Have you allowed traffic from the internal to local host and back? (if its for the internal users)

    Need some details please

    Author Comment

    Hi, thanks for the reply.

    I'm trying to publish the SQL Server to internal users only.  

    I have setup a rule in ISA Server following the guide on the Microsoft site (

    Protocol: TCP Inbound, Port 1433
    From / Listener: Internal, Local Host
    To: (Internal IP address of server)

    When I monitor the connections in the "Logging" section of ISA Server, the connection pops up and it matches the rule name that was created for SQL Server.  There's several items that are displayed which match this rule, one for "Initiated Connection" and another for "Closed Connection".  There's about 36 of these logged for each time an ODBC connection has tried to be setup on an internal computer.

    Everything else works fine for the client computers, i.e. they can access the net, e-mail etc, it's just I can't seem to get this SQL problem sorted.

    Hope this info helps.
    LVL 51

    Accepted Solution


    You don't need to publish the sql server then as 'publishing' is for outside users coming in.
    If the SQL service is running on the ISA server, all you need to do is create a new access rule allowing internal & local host (in the from box) to internal & local host (in the to box).
    In the protocol box, you can either set it for all protocols or just for the MS sql server protocol.

    Author Comment

    So simple!  Thanks very much for that!
    LVL 51

    Expert Comment

    by:Keith Alabaster
    More than welcome :)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Do you have a windows based Checkpoint SmartCenter for centralized Checkpoint management?  Have you ever backed up the firewall policy residing on the SmartCenter?  If you have then you know the hassles of connecting to the server, doing an upgrade_…
    There are several problems reported according slow link speeds or poor performance in TMG 2010, UAG 2010 or ISA 2006. I want to collect here some of the common issues together to give a brief overview what can be the reason. Nevertheless, not all of…
    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!
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    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

    13 Experts available now in Live!

    Get 1:1 Help Now