Unanswered: Cluster:Win2003_R2_X64_SP1+SQL2000Enterprised_SP4, SQL2000 can not run on NodeB,Why?
1、A win2003 Cluster has two node:Node A and NodeB.
2、There are two group on Cluster:
3、The problem is :
GruopA can switch between Node A and NodeB freely;but GruopB can not switch to NodeB,Why?
(1) NodeB's Application event log:
Event ID 17052:[sqsrvres] ODBC sqldriverconnect failed
Event ID 17052:[sqsrvres] checkODBCConnectError:sqlstate=IM002;native error=0;message=[Microsoft][ODBC driver manager]datasource not found and no default driver.
I'm sorry to late.
There is no alias in cliconfg.exe.
I phoned to Microsoft's supporter,we had used tools to fixed ODBC driver,but not function;All so, we had unstalled it,re-install it,no function.The MS's supporter could not find the problem,he thought it's OS's problem.Because the SQL server is an on service server,finally I had to reinstall Win2003.Now it work.
Thanks for MCrowley's advice.Thans everyone.