"Steve" <as@joe.ca> wrote in message
news:uqKNAmSsEHA.2660@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I recently upgrade a WinNT 4 SP6a Proxy server to Win2K SP4 with ISA SP2.
I
> have to allow remote users to connect to a SQL server 7 SP4 on Winnt 4
SP6a
> behind ISA. The IP is static. It was working fine with Proxy but now I
have
> the following with clients on the Web:
>
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Network error and if I
> try SQL Query Analyzer I have
>
> Unable to connect to server xxx.xxx.xxx.xxx
> ODBC:Msg 0, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver] Time out error
>
> I have the ISA port 1433 and 1344 (for the apps running with SQL) opened
and
> listenning . If I run netstat -na on both servers, both show ports as
> listenning. I can telnet the ISA external IP on both ports. ISA client is
> installed on the SQL server.
>
> I ran thru a similar problem when I configured it for the proxy 2 years
ago
> and don't remember what was the problem exactly. With the proxy, I had to
> add wspclnt.ini in the sql server binn folder to map the port 1433 to the
> proxy server and added a connection in SQL server network utility which
was
> mapped to the external IP of the Proxy. I tried it with and without and
> there is no difference. I also remember that I had to use credtool on the
> SQL server. Do I have to do it with ISA?
>
> I'm familiar with ISA and i often have to open ports for apps and it works
> fine so what is diffenrent for SQL server?
>
> Any help would be greatly appreciated.
>
> Thanks in advance.
>
> Steve Amirault
>
>

"Steve" <as@joe.ca> wrote in message
news:uplh6uUsEHA.3412@TK2MSFTNGP14.phx.gbl...
> Yes there is a Server rule. Guess what, by doing it the same way I did it
> with the former proxy, it works. I disabled the server publishing rule,
> added the wspcfg.ini file in the mssql7\binn folder and it works??? At the
> setup time and according to the situations I had with the ISA, I first
> thought that it wouldn't work using the same settings as it was with the
> proxy server but it appears that is not the case.
>
> Thanks anyway.
>
> Steve
>
>
>
> "Scott Harding - MS MVP" <scrockel@**NO_SPAM**hotmail.com> a écrit dans le
> message de news:OJeoP1TsEHA.3200@TK2MSFTNGP09.phx.gbl...
> > Take the firewall client off the SQL server and make sure the default
> > gateway of the SQL server is the ISA server, if that is the route to the
> > internet. Did you make the Server Publishing Rule for the machine?
> >
> > --
> > Scott Harding
> > MCSE, MCSA, A+, Network+
> > Microsoft MVP - Windows NT Server
> >
> > "Steve" <as@joe.ca> wrote in message
> > news:uqKNAmSsEHA.2660@TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I recently upgrade a WinNT 4 SP6a Proxy server to Win2K SP4 with ISA
> SP2.
> > I
> > > have to allow remote users to connect to a SQL server 7 SP4 on Winnt
4
> > SP6a
> > > behind ISA. The IP is static. It was working fine with Proxy but now I
> > have
> > > the following with clients on the Web:
> > >
> > > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Network error and
if
> I
> > > try SQL Query Analyzer I have
> > >
> > > Unable to connect to server xxx.xxx.xxx.xxx
> > > ODBC:Msg 0, Level 16, State 1
> > > [Microsoft][ODBC SQL Server Driver] Time out error
> > >
> > > I have the ISA port 1433 and 1344 (for the apps running with SQL)
opened
> > and
> > > listenning . If I run netstat -na on both servers, both show ports as
> > > listenning. I can telnet the ISA external IP on both ports. ISA client
> is
> > > installed on the SQL server.
> > >
> > > I ran thru a similar problem when I configured it for the proxy 2
years
> > ago
> > > and don't remember what was the problem exactly. With the proxy, I had
> to
> > > add wspclnt.ini in the sql server binn folder to map the port 1433 to
> the
> > > proxy server and added a connection in SQL server network utility
which
> > was
> > > mapped to the external IP of the Proxy. I tried it with and without
and
> > > there is no difference. I also remember that I had to use credtool on
> the
> > > SQL server. Do I have to do it with ISA?
> > >
> > > I'm familiar with ISA and i often have to open ports for apps and it
> works
> > > fine so what is diffenrent for SQL server?
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks in advance.
> > >
> > > Steve Amirault
> > >
> > >
> >
> >
>
>

> Take the firewall client off the SQL server and make sure the default
> gateway of the SQL server is the ISA server, if that is the route to the
> internet. Did you make the Server Publishing Rule for the machine?
>
> --
> Scott Harding
> MCSE, MCSA, A+, Network+
> Microsoft MVP - Windows NT Server
>
> "Steve" <as@joe.ca> wrote in message
> news:uqKNAmSsEHA.2660@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I recently upgrade a WinNT 4 SP6a Proxy server to Win2K SP4 with ISA
SP2.
> I
> > have to allow remote users to connect to a SQL server 7 SP4 on Winnt 4
> SP6a
> > behind ISA. The IP is static. It was working fine with Proxy but now I
> have
> > the following with clients on the Web:
> >
> > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Network error and if
I
> > try SQL Query Analyzer I have
> >
> > Unable to connect to server xxx.xxx.xxx.xxx
> > ODBC:Msg 0, Level 16, State 1
> > [Microsoft][ODBC SQL Server Driver] Time out error
> >
> > I have the ISA port 1433 and 1344 (for the apps running with SQL) opened
> and
> > listenning . If I run netstat -na on both servers, both show ports as
> > listenning. I can telnet the ISA external IP on both ports. ISA client
is
> > installed on the SQL server.
> >
> > I ran thru a similar problem when I configured it for the proxy 2 years
> ago
> > and don't remember what was the problem exactly. With the proxy, I had
to
> > add wspclnt.ini in the sql server binn folder to map the port 1433 to
the
> > proxy server and added a connection in SQL server network utility which
> was
> > mapped to the external IP of the Proxy. I tried it with and without and
> > there is no difference. I also remember that I had to use credtool on
the
> > SQL server. Do I have to do it with ISA?
> >
> > I'm familiar with ISA and i often have to open ports for apps and it
works
> > fine so what is diffenrent for SQL server?
> >
> > Any help would be greatly appreciated.
> >
> > Thanks in advance.
> >
> > Steve Amirault
> >
> >
>
>