Very Computer

SQL Server 2000 Enterprise
Windows 2000 Advanced Server sp1

We set up MSCS on our Win2k machine with three network cards (internal,
external, heartbeat).  We then installed SQL Server 2000 to use an i.p.
address on the same subnet as the internal nic.  We can only connect to the
machine using the SQL Server Name (ie. DBServer) internal and external I.P.
Addresses do not work (192.x.x.x or 64.x.x.x).  Whenever I attempt to
connect using an I.P. Address I receive the following error message...

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

We followed all the installation directions we could compile (Step-by-Step
Cluster Installation, Duwamish Cluster Example, SQL BOL, SQL Server
Administration Companion) and checked the Microsoft Searchable KnowledgeBase
for this error but, we can't seem to find anything we could have missed.

Is there a configuration setting missing here?

Thanks,
Bianca

What's the IP address/subnet mask of the SQL IP Address resource, and what's
the IP address/subnet masks of the IP addresses configured in MSCS?  Is
there more than one address in the SQL Server resource group?

--
Richard Waymire, MCSE, MCDBA

Quote:> SQL Server 2000 Enterprise
> Windows 2000 Advanced Server sp1

> We set up MSCS on our Win2k machine with three network cards (internal,
> external, heartbeat).  We then installed SQL Server 2000 to use an i.p.
> address on the same subnet as the internal nic.  We can only connect to
the
> machine using the SQL Server Name (ie. DBServer) internal and external
I.P.
> Addresses do not work (192.x.x.x or 64.x.x.x).  Whenever I attempt to
> connect using an I.P. Address I receive the following error message...

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

> We followed all the installation directions we could compile (Step-by-Step
> Cluster Installation, Duwamish Cluster Example, SQL BOL, SQL Server
> Administration Companion) and checked the Microsoft Searchable
KnowledgeBase
> for this error but, we can't seem to find anything we could have missed.

> Is there a configuration setting missing here?

> Thanks,
> Bianca

After doing some more research, I found a solution in KnowledgeBase Article
Q244980

-Bianca