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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment