Connection problem to SQL 2000 cluster

Hello all! I have set up a SQL 2000 cluster and I have installed SQL 2000
Reporting Services on another server. Both servers are on the same IP subnet
(10.10.100.x/24) and both connected to the same network switch. I cannot
connect to port 1433 of the SQL cluster from the RS server. However, I can
connect to port 1433 on the RS server from the cluster. Also, I can connect
to port 1433 on the cluster from some web servers in the DMZ. There is no
firewall software running on the cluster. I'm not sure where to start
looking next. Any help would be appreciated. Thanks!
Ports are meaningful per IP address, and there are a number of different IP
addresses or network names in a cluster. Can you verify that you are using
the right network name or IP address for the SQL Server instance?
Linchi
"mdap" wrote:

> Hello all! I have set up a SQL 2000 cluster and I have installed SQL 2000
> Reporting Services on another server. Both servers are on the same IP subnet
> (10.10.100.x/24) and both connected to the same network switch. I cannot
> connect to port 1433 of the SQL cluster from the RS server. However, I can
> connect to port 1433 on the RS server from the cluster. Also, I can connect
> to port 1433 on the cluster from some web servers in the DMZ. There is no
> firewall software running on the cluster. I'm not sure where to start
> looking next. Any help would be appreciated. Thanks!
|||Linchi,
Thanks for the reply. Yes, I have confirmed that I am attempting to connect
to the right IP and network name of the SQL server instance.
At any rate, I can occasionally connect to the SQL server from the RS
server. I did a packet trace, and I found that I've got a problem with ARP.
(The cluster sees traffic coming from the MAC address of the network firewall
instead of from the RS server.) Anyway, when I clear the ARP cache on both
servers, I can establish a connection for a few minutes. After that, the
problem resurfaces. I think that the problem is the network switch, so I'm
going to replace that tomorrow and see if it helps.
"Linchi Shea" wrote:
[vbcol=seagreen]
> Ports are meaningful per IP address, and there are a number of different IP
> addresses or network names in a cluster. Can you verify that you are using
> the right network name or IP address for the SQL Server instance?
> Linchi
> "mdap" wrote: