none
HCK Controller installation fails - SQL Client Components required ... RRS feed

  • Question

  • Hi,

    I am trying to install the HCK Controller on a Windows 2008 Server R2 SP1 and get the error:

    CAQuietExec:  Error::
    ************************************************************ERROR REPORT (Exception levels including inner exceptions. Level 0 denotes outermost exception)
    CAQuietExec: 
    CAQuietExec:  ------------START OF ERROR REPORT------------
    CAQuietExec: 
    CAQuietExec:  Level            : 0
    CAQuietExec:  Error Message    : SQL client components are required for this operation, please install SQL client tools onto the machine that this operation is being carried on and try again.
    CAQuietExec:  Source           : Void CreateEnterprise(Microsoft.DistributedAutomation.DSLink, Microsoft.DistributedAutomation.ServiceCollection, Boolean)
    CAQuietExec:  Inner Exception  : System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {100202C1-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.
    CAQuietExec:     at Microsoft.DistributedAutomation.SqlDataStore.SqlDataStoreSetup.IsValidSqlServer(String serverName, String databaseName)
    CAQuietExec:  Call Stack       :    at Microsoft.DistributedAutomation.SqlDataStore.SqlDataStoreSetup.CreateEnterprise(DSLink identityDSLink, ServiceCollection serviceList, Boolean standaloneInstall)
    CAQuietExec:     at Microsoft.DistributedAutomation.EnterpriseSetup.EnterpriseSetupHelper.CreateEnterprise(EnterpriseConfiguration enterpriseConfig, DSLink dsLink, String setupFilePath, Boolean standaloneInstall)
    CAQuietExec:     at Microsoft.DistributedAutomation.EnterpriseSetup.Tools.CMain.Main(String args)
    CAQuietExec:  Trace            :
    CAQuietExec: 
    CAQuietExec:  Level            : 1
    CAQuietExec:  Error Message    : Retrieving the COM class factory for component with CLSID {100202C1-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.
    CAQuietExec:  Source           : Boolean IsValidSqlServer(System.String, System.String)
    CAQuietExec:  Inner Exception  :
    CAQuietExec: 
    CAQuietExec:  --------------END OF ERROR REPORT------------************************************************************
    CAQuietExec:  Error 0x80070001: Command line returned an error.
    CAQuietExec:  Error 0x80070001: CAQuietExec Failed
    CustomAction CreateStandaloneEnterprise returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)

    ...looks like some SQL clients software is missing but what do i need to install to make this work?

    Thanks

    Alex

    Wednesday, March 27, 2013 4:30 PM

All replies

  • Did the system already have an instance of SQL pre-installed before you attempted HCK Controller install?  If so, you might want to attempt to install HCK Controller on a separate, clean system to alleviate any trouble you might encounter, as we install an instance of SQL which satisfies all of our requirements to run HCK Controller.  Optionally, if you are able to uninstall all instance of SQL, which may be potentially conflicting on the existing system, then attempting to install HCK Controller should once again install any SQL components we require automatically.

    We provide some documentation and help for customers who wish to maintain their own version of SQL, but you must make sure it is installed using these options;

    http://msdn.microsoft.com/en-us/library/windows/hardware/hh998800.aspx

    Wednesday, March 27, 2013 5:13 PM
  • Hi Jason,

    no that was a clean install of Windows Server 2008 R2 SP1 - but I installed the German version and added the english language pack after that to change the server to th en_us locale. (which worked fine btw.)

    Do you think this might couse any problems? Because I had other strage effects e.g. that I had to rename the Administrators User Group actualle to "Administrators" because it was a localized german name ...

    Thanks

    Alex

    Wednesday, March 27, 2013 5:44 PM
  • Adding a language pack to a non-English US scenario isn't supported -- the base OS has to be the en-us version for the controller.  Our install block should have caught this though, was this just installed through using the manual UX install?

    -g


    This posting is provided "AS IS" with no warranties, and confers no rights

    Wednesday, April 3, 2013 8:16 PM
  • just want to let you all know that I started over using a clean fresh install of the en_us vesion of Windows Server 2008 R2 SP1 and the installation went through w/o any problems.

    So it is really no problem on a clean install of the en_us version ...

    Thanks to all

    Alex

    Thursday, April 4, 2013 1:45 PM
  • I've faced with same issue. Tried both Windows Server 2008 R2 x64 SP1 En and 2012 x64 En.

    OS was freshly installed. Any idea how to fix that?

    CAQuietExec:  Standalone Enterprise setup started by user WIN-0TANJJ711RT\Administrator
    CAQuietExec:  Error::
    ************************************************************ERROR REPORT (Exception levels including inner exceptions. Level 0 denotes outermost exception)
    CAQuietExec:  
    CAQuietExec:  ------------START OF ERROR REPORT------------
    CAQuietExec:  
    CAQuietExec:  Level            : 0
    CAQuietExec:  Error Message    : SQL client components are required for this operation, please install SQL client tools onto the machine that this operation is being carried on and try again.
    CAQuietExec:  Source           : Void CreateEnterprise(Microsoft.DistributedAutomation.DSLink, Microsoft.DistributedAutomation.ServiceCollection, Boolean)
    CAQuietExec:  Inner Exception  : System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {100202C1-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
    CAQuietExec:     at Microsoft.DistributedAutomation.SqlDataStore.SqlDataStoreSetup.IsValidSqlServer(String serverName, String databaseName)
    CAQuietExec:  Call Stack       :    at Microsoft.DistributedAutomation.SqlDataStore.SqlDataStoreSetup.CreateEnterprise(DSLink identityDSLink, ServiceCollection serviceList, Boolean standaloneInstall)
    CAQuietExec:     at Microsoft.DistributedAutomation.EnterpriseSetup.EnterpriseSetupHelper.CreateEnterprise(EnterpriseConfiguration enterpriseConfig, DSLink dsLink, String setupFilePath, Boolean standaloneInstall)
    CAQuietExec:     at Microsoft.DistributedAutomation.EnterpriseSetup.Tools.CMain.Main(String args)
    CAQuietExec:  Trace            : 
    CAQuietExec:  
    CAQuietExec:  Level            : 1
    CAQuietExec:  Error Message    : Retrieving the COM class factory for component with CLSID {100202C1-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
    CAQuietExec:  Source           : Boolean IsValidSqlServer(System.String, System.String)
    CAQuietExec:  Inner Exception  : 
    CAQuietExec:  
    CAQuietExec:  --------------END OF ERROR REPORT------------************************************************************
    CAQuietExec:  Error 0x80070001: Command line returned an error.
    CAQuietExec:  Error 0x80070001: CAQuietExec Failed
    CustomAction CreateStandaloneEnterprise returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
    08/14/2013 15:19:38.233 [2056]: Assembly Install: Failing with hr=80070005 at RemoveDirectoryAndChildren, line 398

    08/14/2013 15:19:38.233 [2056]: Detailed info about C:\Windows\assembly\tmp\FH3A3D0C\microsoft.wtt.log.dll

    08/14/2013 15:19:38.233 [2056]: File attributes: 00000080

    08/14/2013 15:19:38.264 [2056]: Restart Manager Info: 1 entries

    08/14/2013 15:19:38.264 [2056]: App[0]: (2056) Windows Installer (msiserver), type = 3 

    08/14/2013 15:19:38.264 [2056]: Security info:

    08/14/2013 15:19:38.264 [2056]: Owner: S-1-5-18

    08/14/2013 15:19:38.264 [2056]: Group: S-1-5-18

    08/14/2013 15:19:38.264 [2056]: DACL information: 4 entries:

    08/14/2013 15:19:38.264 [2056]: ACE[0]: Type = 0x00, Flags = 010, Mask = 001f01ff, SID = S-1-5-18

    08/14/2013 15:19:38.264 [2056]: ACE[1]: Type = 0x00, Flags = 010, Mask = 001f01ff, SID = S-1-5-32-544

    08/14/2013 15:19:38.264 [2056]: ACE[2]: Type = 0x00, Flags = 010, Mask = 001200a9, SID = S-1-5-32-545

    08/14/2013 15:19:38.264 [2056]: ACE[3]: Type = 0x00, Flags = 010, Mask = 001200a9, SID = S-1-15-2-1

    MSI (s) (08:38) [15:19:38:280]: Note: 1: 2265 2:  3: -2147287035 
    MSI (s) (08:38) [15:19:38:280]: User policy value 'DisableRollback' is 0
    MSI (s) (08:38) [15:19:38:280]: Machine policy value 'DisableRollback' is 0
    Action ended 15:19:38: InstallFinalize. Return value 3.
    Wednesday, August 14, 2013 12:43 PM
  • What version of the kit is this occurring on (release+QFE)?  Also has any HCK component (or component that HCK uses) been installed and/or downloaded on that system before the install?

    This posting is provided "AS IS" with no warranties, and confers no rights


    Wednesday, August 14, 2013 5:57 PM
  • I've tried in the next order:

    1.Install Win 2008 R2 SP1

    2. Try to install HCK 2.1 with HCKSetup.exe file version 8.100.9621

    3. Reinstall Win 2012

    4. Try to install HCK 2.1 with HCKSetup.exe file version 8.100.9621

    5. Try to install HCK 2.1 with HCKSetup.exe file version 8.100.9624

    No other software was installed prior to HCK installation attemts.

    Thursday, August 15, 2013 8:04 AM
  • I haven't been able to reproduce this issue :(.

    Was Server 2012 installed over the top of 2008 R2?  Was HCK 2.1 (or a previous version/release of HCK) installed/downloaded on the same machine previously?


    This posting is provided "AS IS" with no warranties, and confers no rights

    Wednesday, August 21, 2013 3:03 AM
  • This issue is backward compatibility i guess. When you install SQL 2008 / the SLQ server2005 backward compatibility is not installed by default. quickest way to find if this is the issue

    go to C:\program files (x86)\Microsoft sqlserver\80\Tools\Binn and check if sqldmo.dll is present, it will be missing. If you run the Backward compatibility wizard if may error out. If this is the scenario , here are the steps to fix

    Go to sql server 2008 features pack ( depending on what SP you have) my case it was SP3.

    http://www.microsoft.com/en-us/download/details.aspx?id=27596

    install the X64 related features and this does have BC.msi for backward compatibility but probably dependent on another feature install. So i installed most of them in order to install BC. Once done check the BINN folder mentioned above again, you will find the sqldmo.dll file there this time.

    Try your app install and it will not error out for CLSID not found. THe steps above are 2008 64 bit but these should work well for 32 bit. just change the path to check.

    Feel free to ping if you still could not resolve. Enjoy coding !

    • Proposed as answer by Poonam K Gill Friday, October 25, 2013 7:22 PM
    Friday, October 25, 2013 7:22 PM