Friday, February 10, 2012

Cluster:Win2003_R2_X64_SP1+SQL2000Enterprised_SP4, SQL2000 can not run on NodeB

1、A win2003 Cluster has two node:Node A and NodeB.
2、There are two group on Cluster:
GroupA:ClusterIP,ClusterName,ClusterDisk;
GruopB:SQLServer,DataDisk;
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.

Thanks for your help!Is there an alias for group 2's SQL Server listed in cliconfg.exe? (Client Network Config tool)|||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.|||Smells like a service pack problem to me. See the previous post (http://www.dbforums.com/showthread.php?t=1612152) on this subject.

-PatP

No comments:

Post a Comment