SQL2005 Freezing during install into a cluster

  • Help!, I am trying to install sql server 2005sp1 onto a cluster. I have installed 6 other instances on this cluster with no problem. Now I am going to install and it is just hanging. The status window shows it is at the Installing WMI registration on the primary node and Removing backup files on the secondary node. Looking at the log files I see no errors. On the primary node here is a snippet of the last couple of lines from the log

    Succeeded.

    Configuring ACL:

    Object: SQLWriter

    ACL: (A;NP;0x00020011;;;[UHMC\SQLServiceAccounts])

    Action: 0x100

    Succeeded.

    <EndFunc Name='Do_sqlServiceSDDL' Return='0' GetLastError='0'>

    PerfTime Stop: Do_sqlServiceSDDL : Tue Oct 26 10:09:44 2010

    MSI (s) (28:F8) [10:09:44:192]: Executing op: ActionStart(Name=Do_sqlMofcomp.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B,Description=Installing WMI registration,)

    <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>

    MSI (s) (28:F8) [10:09:44:192]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof)

    MSI (s) (28:40) [10:09:44:208]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI484.tmp, Entrypoint: Do_sqlMofcomp

    <Func Name='LaunchFunction'>

    Function=Do_sqlMofcomp

    <Func Name='GetCAContext'>

    <EndFunc Name='GetCAContext' Return='T' GetLastError='0'>

    Doing Action: Do_sqlMofcomp

    PerfTime Start: Do_sqlMofcomp : Tue Oct 26 10:09:44 2010

    On the secondary node here are the last couple of lines as well.. I just have no idea what else I can try. Its frustating no even having a real error message to troubleshoot off of.

  • Please check if the file "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof" exists.

    If it does not exist you can copy it from a server which is of the same build. It had worked for me sometime back

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Thank you for your reply! But alas that file does exist and is same version/date/size as my other servers with same build.

  • <<continued>>

    frustating no even having a real error message to troubleshoot off of.

    MSI (s) (9C:50) [10:09:50:985]: Executing op: CleanupTempFiles(TempFiles=C:\WINDOWS\Installer\303377.msp)

    MSI (s) (9C:50) [10:09:50:985]: Scheduling file 'C:\WINDOWS\Installer\303377.msp' for deletion during post-install cleanup (not post-reboot).

    MSI (s) (9C:50) [10:09:50:985]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=273307712)

    MSI (s) (9C:50) [10:09:50:985]: User policy value 'DisableRollback' is 0

    MSI (s) (9C:50) [10:09:50:985]: Machine policy value 'DisableRollback' is 0

    MSI (s) (9C:4C) [10:09:51:032]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI1A6.tmp, Entrypoint: Set_CommitFlag

    <Func Name='LaunchFunction'>

    Function=Set_CommitFlag

    <Func Name='GetCAContext'>

    <EndFunc Name='GetCAContext' Return='T' GetLastError='0'>

    Doing Action: Set_CommitFlag

    PerfTime Start: Set_CommitFlag : Tue Oct 26 10:09:51 2010

    <Func Name='Set_CommitFlag'>

    It has been stuck this way for over an hour now. I see no errors in the event log, I am not seeing any crazy runaway processes. This happened to me yesterday so I cancelled out of the install, I uninstalled that instance as it had been partially installed on both nodes, rebooted both nodes and tried the install again .. and still having the same problem.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply