Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    3

    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:
    GroupA:ClusterIP,ClusterName,ClusterDisk;
    GruopBQLServer,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!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Is there an alias for group 2's SQL Server listed in cliconfg.exe? (Client Network Config tool)

  3. #3
    Join Date
    Nov 2006
    Posts
    3
    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.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Smells like a service pack problem to me. See the previous post on this subject.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •