Re: Can't connect to SQL Server through ISA

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Phillip Windell (_at_.)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 16:13:35 -0600

"Hoof Hearted" <HoofHearted@discussions.microsoft.com> wrote in message
news:D8AEAC67-363E-44AA-A7D5-4A9B19A56330@microsoft.com...
> SBS 2003: I can't connect into my SQL server from the outside world.
However
> I've noticed that I can connect briefly immediately after the server has
been
> rebooted. I assume this must be because SQL Server starts prior to ISA. I
can
> connect perfectly on the internal network. But only by using the internal
IP
> address. I can't connect by using the server name.

If you can connect by using the internal IP as the "target" then you have a
severly flawed design. The internal IP#s should never be able to be used as
"destinations" and they should not even be "routable" from the Public
Network.

> I don't know much about ISA, but various KB articles say that all I need
is
> a Protocol Definition for TCP Port 1433 outbound, and a Protocol Rule
which
> makes use of the definition.

No, this is so a user behind ISA can connect to an SQL Server that is on the
outside out there in Internet Land.

For a user outside in Internet Land to access a SQL Server that is behind
the proxy requires the proxy to "Publish" the SQL Server using the Server
Publishing Features of ISA. 

-- 
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com

Relevant Pages

  • Re: Port Forwarding
    ... >> If you still can't access internet check the proxy settings in IE. ... >> DO NOT install the firewall client on the server. ... >>> Just installed SQL Server and ISA. ...
    (microsoft.public.windows.server.sbs)
  • Connecting to SQL server 7 behind ISA server
    ... [ODBC SQL Server Driver] ... I can telnet the ISA external IP on both ports. ... I ran thru a similar problem when I configured it for the proxy 2 years ago ...
    (microsoft.public.isaserver)
  • Connecting to SQL server 7 behind ISA server
    ... [ODBC SQL Server Driver] ... I can telnet the ISA external IP on both ports. ... I ran thru a similar problem when I configured it for the proxy 2 years ago ...
    (microsoft.public.sqlserver.connect)
  • Re: Best Pratice-Remore ADO Access
    ... > end app will be installed on clients and the SQL Server ... > use the Internet to move data back and forth. ... >> data over a WAN connection to a SQL Server. ... >> INSERT clause would be the most efficient method, ...
    (microsoft.public.vb.database.ado)
  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)