Premise 2015.1.1: Constructor or Binding Constraints error in the System Configuration Wizard

Version 1

    Details

    When using the System Configuration Wizard, especially in 2015.1.1 on-Premise, and especially when first launching the wizard, an unavoidable error may be received:


    The invocation of the constructor on type 'ServerConfigurationWizard.UserControls.SQLServerSelector' that matches the specified binding constraints threw an exception.

     


    Resolution

    The key thing to know about this error is that logging may not occur where you set it. For example, D:\HEATLogs.  It will likely be present in the C:\Logs directory.  Look for the SystemConfigurationWizard or ServerConfigurationWizard log.


    It will likely give an indication of an error like the following:

    "The CRT binary present in application/bin folder is not signed and can be a potential security risk. Please place the original Microsoft CRT binary in application/bin folder.".

    This StackOverflow.com article provides further detail, but the simple solution is likely that a setting on server-level Internet Options for Publisher Certificate Revocation is likely preventing the function in the error from connecting to the available SQL Instances.  The workaround is to adjust the setting, which is done by:

    1. Opening RegEdit and locating HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing

     2. Looking for a DWORD key with the name "State" 

    2a. If it does not exist, create it.

    2b. Whether creating it, or updating it, assign it the HEX value of "23e00".

    As discussed in the article, this corresponds to the Internet Options / Advanced setting "Check for publisher’s certificate Revocation" being unchecked (see the linked KB article above).  The reason you may need to do this in the Registry, however, is because many times automated Security Policy will refresh this setting on every reboot, and this setting (unless changed in the Registry) requires a reboot to take effect.