"Curtis Morrison" <curtmorrison@hotmail.com> wrote in message
news:1174920700.449721.209260@l77g2000hsb.googlegroups.com...
> I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on
> Windows 2003 Server Enterprise Edition SP1. I changed the subnet mask
> of my public network config, as well as the MCS virtual subnet and two
> database resource subnets (all are using the same subnet). DNS is
> correctly resolving to the IP addresses for all cluster resources. I
> have two databases on this cluster. After changing the subnet, the
> first one starts correctly on both nodes. The second one fails to
> start at the SQL Server resource on node 1, but starts correctly on
> node 2. I've included the three major application log errors below.
>
> Before I start troubleshooting any further, I'm looking for any
> suggestions. Does anyone know if running the SQL Server installation
> advanced options mode would make any difference? Could a machine
> reboot be necessary?
>
> Type: Error
> User: N/A
> Source: MSSQL$LCCSQLINST1
> Category: (3)
> Event ID: 17052
>
> Description:
> [sqsrvres] ODBC sqldriverconnect failed
>
> =======================================
>
> Type: Error
> User: N/A
> Source: MSSQL$LCCSQLINST1
> Category: (3)
> Event ID: 17052
>
> Description:
> [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11;
> message = [Microsoft][ODBC SQL Server
>
> Driver][DBNETLIB]SQL Server does not exist or access denied.
>
> =======================================
>
> Type: Error
> User: N/A
> Source: MSSQL$LCCSQLINST1
> Category: (3)
> Event ID: 17052
>
> Description:
> [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35;
> message = [Microsoft][ODBC SQL Server
>
> Driver][DBNETLIB]ConnectionOpen (Connect()).
>
> =======================================
>
> Thanks,
> Curt
>