Re: Can't connect to SQL Server through ISA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ori Yosefi [MSFT] (oriy_at_online.microsoft.com)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 15:17:59 +0200

I'm not sure that I understand your problem.

Did you try to create an access rule from the external network to the local
host, allowing SQL queries? Did it not work?

You can turn on the logging and check what happens with the traffic, if it
is denied, and if so - try to see why.

Please provide further details of your problem and I will try to assist if I
can.

Ori. 

-- 
This posting is provided "AS IS" with no warranties, and
confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup 
purposes only.
Ori Yosefi[MSFT] ISA Server Team
"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.
>
> 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.
>
> I'm struggling. Can anyone help?
>

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)