Subject: SQL 2000 Clustered fail to start

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Moshe K - 21 Jul 2005 14:14 GMT

Hi,
I have SQL2000 installed on a cluster. The service is starting, but the
cluster fails to detect it started. in event log i get:
1:[sqsrvres] ODBC sqldriverconnect failed
2:[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11;
message = [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not
exist or access denied.
3:[sqsrvres] ODBC sqldriverconnect failed
4:[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35;
message = [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(Connect()).

did anyone expiriance such problem?
Thanks in advance,
Moshe K.

Reply to this Message

Vikram Vamshi - 22 Jul 2005 19:28 GMT

This could be a name resolution issue.
Try pinging your virtual server by name from the node which currently owns
the sql server resource.
See if it properly resoves the name to the virtual ip address
hth

Signature

Vikram Vamshi
Database Engineer
Eclipsys Corporation

> Hi,
> I have SQL2000 installed on a cluster. The service is starting, but the
[quoted text clipped - 12 lines]
> Thanks in advance,
> Moshe K.

Reply to this Message