question

11717922 avatar image
0 Votes"
11717922 asked AmeliaGu-msft answered

SSMS instalation failed

Hi)
Could you please advise why I receive a fail message when installing SSMS?

Error message: "A certificate was explicitly revoked by its issuer ("0x800B010C)
This happens either with the newest version or with the previous ones.
I tried to run it as administrator, turn off the VPN - no results.

Please help)))

Thank you in advance!

P.S. In case you need a log message:
[3BD4:1ED4][2021-07-31T13:01:49]i001: Burn v3.8.1128.0, Windows v6.3 (Build 9600: Service Pack 0), path: C:\Users\Vadym\Downloads\SSMS-Setup-ENU.exe, cmdline: '-burn.unelevated BurnPipe.{F9ABDEC5-442C-437F-BD78-2F728CA04E28} {E6D1109E-ADA8-469A-8E96-2EFE75CB469E} 9320'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SSMSINSTALLROOT' to value '[ProgramFilesFolder]Microsoft SQL Server Management Studio 18'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing numeric variable 'SSMSInstallExists' to value '0'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SSMSInstalledLanguageKeyExists' to value 'false'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SSMSInstalledLanguageMatch' to value 'true'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SSMS18PreReleaseDetected' to value 'false'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SSMS18InstalledVersion' to value ''
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'AzureDataStudioInstalledVersion' to value ''
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'AzureDataStudioInstalledVersionInsider' to value ''
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing numeric variable 'AzureDataStudioInstallExists' to value '0'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing numeric variable 'AzureDataStudioInstallExistsInsider' to value '0'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'AzureDataStudioVersion' to value '1.27.0'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing numeric variable 'DONOTINSTALLAZUREDATASTUDIO' to value '0'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'ProductVersionVar' to value '15.0.18382.0'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'HeaderText' to value 'Release 18.9'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SubHeaderText' to value 'Microsoft SQL Server Management Studio with Azure Data Studio'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'LicenseTermsSSMSUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x[System.Convert]::ToInt32(1033)'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'LicenseTermsADSUrl' to value 'https://go.microsoft.com/fwlink/?linkid=2140322&clcid=0x[System.Convert]::ToInt32(1033)'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'PreviewStatementUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=824140'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'TelemetryDocumentationUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=869476'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing numeric variable 'InstallerLcid' to value '1033'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'CancelText' to value 'C_ancel'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'CloseText' to value '_Close'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'ContinuePastWarningText' to value 'Do you wish to continue?'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'InstallText' to value '_Install'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'LicenseTermsSSMSText' to value 'SQL Server Management Studio'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'LicenseTermsADSText' to value 'Azure Data Studio'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'LoadingPackagesText' to value 'Loading packages. Please wait...'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'OverallProgressText' to value 'Overall Progress'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'PackageProgressText' to value 'Package Progress'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'PrivacyStatementText' to value 'Privacy Statement'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'TelemetryDocumentationText' to value 'documentation'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'PrivacyDisclaimerText' to value 'SQL Server Management Studio transmits information about your installation experience, as well as other usage and performance data, to Microsoft to help improve the product. To learn more about data processing and privacy controls, and to turn off the collection of this information after installation, see the {documentation}.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'RepairText' to value 'Repair'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'RestartText' to value 'Restart'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupBlockedDescriptionText' to value 'Something has blocked setup from continuing.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupBlockedText' to value 'Setup Blocked'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupCanceledDescriptionText' to value 'The setup operation has been canceled.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupCanceledText' to value 'Setup Canceled'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupCompletedText' to value 'Setup Completed'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupFailedDescriptionText' to value 'A failure occured during installation.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupFailedText' to value 'Setup Failed'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupHelpDescriptionText' to value '/install | /repair | /uninstall - installs, repairs, or uninstalls. Install is the default.

/passive | /quiet - displays minimal UI with no prompts or displays no UI and no prompts. By default, UI and all prompts are displayed.

/norestart - suppress any attempts to restart. By default, UI will prompt before restart.

/log <logfile prefix> - the prefix for SSMS setup logs. By default, log files are created under %TEMP%\SSMSSetup.

SSMSInstallRoot=<Path to SSMS location>. By default, {0}.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupHelpText' to value 'Setup Help'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupInstalledText' to value 'All specified components have been installed successfully.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupLayoutText' to value 'Layout operation has completed.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupLogText' to value 'Click here for the log file.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupProgressText' to value 'Setup Progress'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupRepairedText' to value 'All specified components have been repaired successfully.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupRestartDescriptionText' to value 'The computer needs to be restarted before setup can continue.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupRestartText' to value 'Restart required in order to complete setup.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupUninstalledText' to value 'All specified components have been uninstalled successfully.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupWarningDescriptionText' to value 'The following issues may impact the installed application.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SetupWarningText' to value 'Setup Warnings'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'TermsAndConditionText' to value 'By clicking the "Install" button, I acknowledge that I accept the {Privacy Statement} and the License Terms for {SQL Server Management Studio} and {Azure Data Studio}.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'UninstallText' to value 'Uninstall'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'WelcomeInstallText' to value 'Welcome. Click "Install" to begin.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'YesText' to value 'Yes'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'RestartAlreadyPending' to value 'A pending restart is blocking setup from completing. Please restart the computer and run setup again.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'AnotherInstallRunning' to value 'Setup is blocked due to another install currently running. Please let the other install complete and then restart the computer if necessary.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'SSMSCurrentlyRunning' to value 'SSMS is currently running. Please close any open instances of SSMS and run this installer again.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'AzureDataStudioCurrentlyRunning' to value 'Azure Data Studio is currently running. Please close any open instances of Azure Data Studio and run this installer again.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'MinimizeButtonAccessibleName' to value 'Minimize'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'Win10OrWS2016NotSupported' to value 'This version of Windows 10 or Windows Server 2016 is not supported. Please upgrade to version 1607 or greater.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'IsUpgradeScenario' to value 'false'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'ChangeText' to value 'C_hange'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'LocationText' to value '_Location:'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Initializing string variable 'InvalidLocationText' to value 'Invalid location. Please enter a valid location to proceed.'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149.log'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Setting string variable 'WixBundleOriginalSource' to value 'C:\Users\Vadym\Downloads\SSMS-Setup-ENU.exe'
[3BD4:1ED4][2021-07-31T13:01:49]i000: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Management Studio - 18.9'
[3BD4:1ED4][2021-07-31T13:01:50]i000: Loading managed bootstrapper application.
[3BD4:1ED4][2021-07-31T13:01:50]i000: Creating BA thread to run asynchronously.
[3BD4:1448][2021-07-31T13:01:59]i000: ManagedBootstrapperApp.Run: Launching the managed bootstrapper application.
[3BD4:1448][2021-07-31T13:01:59]i000: BootstrapperMetadataModel.Initialize: Start loading the bootstrapper app data xml file
[3BD4:1448][2021-07-31T13:01:59]i000: BootstrapperMetadataModel.Initialize: Completed loading the bootstrapper app data xml file content: <BootstrapperApplicationData xmlns="http://schemas.microsoft.com/wix/2010/BootstrapperApplicationData">;
<WixBalCondition Condition="SSMS18PreReleaseDetected = 0" Message="The Generally Available (GA) version of SQL Server Management Studio (SSMS) v18.0 cannot be installed because a pre-release version of SSMS is installed on your computer. Uninstall the pre-release version of SSMS from 'Add/Remove Programs' in the Control Panel and run SSMS setup again." />
<WixBalCondition Condition="(SSMS18PreReleaseDetected = 1) OR (SSMSInstallExists = 0) OR (SSMSInstalledLanguageKeyExists = 0) OR SSMSInstalledLanguageMatch" Message="SSMS can only be upgraded by installing the package of the matching language. Please, use the matching version of the installer, or uninstall the current version of SSMS and run SSMS setup again." />
<WixBalCondition Condition="NOT Msix64" Message="SSMS can only be installed on 64-bit versions of Windows." />
<WixBalCondition Condition="RebootPending = 0" Message="Setup has detected that a computer restart is pending. Please restart the computer and run Setup again" />
<WixBalCondition Condition="(VersionNT = v6.1 AND ServicePackLevel = 1) OR VersionNT &gt; v6.1" Message="The current operating system is not supported. This application requires at least Windows 7 SP1 or Windows Server 2008 R2 SP1 to run." />
<WixBalCondition Condition="Installed OR (VersionNT &lt;&gt; v6.2) OR (InstallationType &lt;&gt; &quot;Client&quot;)" Message="Windows 8 is not supported. Please upgrade your operating system to continue." />
<WixBalCondition Condition="(VersionNT &lt;&gt; v6.3) OR (KB2919355_amd64_CurrentState = 112 OR KB2919355_x86_CurrentState = 112)" Message="The update corresponding to KB2919355 needs to be installed before you can install this product on Windows 8.1 or Windows Server 2012 R2. Please refer to https://support.microsoft.com/en-us/kb/2919355/ to obtain and install this update." />
<WixBundleProperties DisplayName="Microsoft SQL Server Management Studio - 18.9" LogPathVariable="WixBundleLog" Compressed="no" Id="{9d5158d0-90da-41c5-823a-93973caaf861}" UpgradeCode="{C55E865B-F94F-42FC-A95A-00F24602F1C2}" PerMachine="yes" />
<WixMbaPrereqInformation PackageId="NetFx45Web" LicenseUrl="http://go.microsoft.com/fwlink/?LinkID=260867" />
<WixPackageProperties Package="VCRedistD12x86" Vital="no" DisplayName="Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.30501" Description="Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.30501" DownloadSize="6503984" PackageSize="6503984" InstalledSize="6503984" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VCRedistD12x86" RollbackLogPathVariable="WixBundleRollbackLog_VCRedistD12x86" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="VCRedistD14x86" Vital="no" DisplayName="Microsoft Visual C++ 2017 Redistributable (x86) - 14.16.27029" Description="Microsoft Visual C++ 2017 Redistributable (x86) - 14.16.27029" DownloadSize="14673288" PackageSize="14673288" InstalledSize="14673288" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VCRedistD14x86" RollbackLogPathVariable="WixBundleRollbackLog_VCRedistD14x86" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="VCRedistD14x64" Vital="no" DisplayName="Microsoft Visual C++ 2017 Redistributable (x64) - 14.16.27029" Description="Microsoft Visual C++ 2017 Redistributable (x64) - 14.16.27029" DownloadSize="15354672" PackageSize="15354672" InstalledSize="15354672" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VCRedistD14x64" RollbackLogPathVariable="WixBundleRollbackLog_VCRedistD14x64" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="HelpViewer2_3" Vital="yes" DisplayName="Microsoft Help Viewer 2.3" DownloadSize="3149592" PackageSize="3149592" InstalledSize="13682786" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_HelpViewer2_3" RollbackLogPathVariable="WixBundleRollbackLog_HelpViewer2_3" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="DotNet47" Vital="yes" DisplayName="Microsoft .NET Framework 4.7.2" Description="Microsoft .NET Framework 4.7.2 Setup" DownloadSize="83943272" PackageSize="83943272" InstalledSize="83943272" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_DotNet47" RollbackLogPathVariable="WixBundleRollbackLog_DotNet47" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="NetFx45Web" Vital="yes" DisplayName="Microsoft .NET Framework 4.5" Description="Microsoft .NET Framework 4.5 Setup" DownloadSize="1005568" PackageSize="1005568" InstalledSize="1005568" PackageType="Exe" Permanent="yes" LogPathVariable="NetFx45FullWebLog" RollbackLogPathVariable="WixBundleRollbackLog_NetFx45Web" Compressed="no" DisplayInternalUI="no" />
<WixPackageProperties Package="sqlncli.msi" Vital="yes" DisplayName="Microsoft SQL Server 2012 Native Client " DownloadSize="5079040" PackageSize="5079040" InstalledSize="10221664" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sqlncli.msi" RollbackLogPathVariable="WixBundleRollbackLog_sqlncli.msi" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="msodbcsql.msi" Vital="yes" DisplayName="Microsoft ODBC Driver 17 for SQL Server" DownloadSize="4640768" PackageSize="4640768" InstalledSize="13830274" PackageType="Msi" Permanent="yes" LogPathVariable="WixBundleLog_msodbcsql.msi" RollbackLogPathVariable="WixBundleRollbackLog_msodbcsql.msi" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="msoledbsql.msi" Vital="yes" DisplayName="Microsoft OLE DB Driver for SQL Server" DownloadSize="7434240" PackageSize="7434240" InstalledSize="15749736" PackageType="Msi" Permanent="yes" LogPathVariable="WixBundleLog_msoledbsql.msi" RollbackLogPathVariable="WixBundleRollbackLog_msoledbsql.msi" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="sql_as_oledb_x64" Vital="yes" DisplayName="Microsoft Analysis Services OLE DB Provider" DownloadSize="77770752" PackageSize="77770752" InstalledSize="510809864" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_as_oledb_x64" RollbackLogPathVariable="WixBundleRollbackLog_sql_as_oledb_x64" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="sql_as_oledb_x86" Vital="yes" DisplayName="Microsoft Analysis Services OLE DB Provider" DownloadSize="38191104" PackageSize="38191104" InstalledSize="249119643" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_as_oledb_x86" RollbackLogPathVariable="WixBundleRollbackLog_sql_as_oledb_x86" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="VS2017IsoShellForSSMS" Vital="yes" DisplayName="Visual Studio 2017 Isolated Shell for SSMS" DownloadSize="142082048" PackageSize="142082048" InstalledSize="418962877" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_VS2017IsoShellForSSMS" RollbackLogPathVariable="WixBundleRollbackLog_VS2017IsoShellForSSMS" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="VSTA2017" Vital="yes" DisplayName="Microsoft Visual Studio Tools for Applications 2017" Description="Microsoft Visual Studio Tools for Applications 2017" DownloadSize="13395792" PackageSize="13395792" InstalledSize="13395792" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VSTA2017" RollbackLogPathVariable="WixBundleRollbackLog_VSTA2017" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="sql_ssms_x64" Vital="yes" DisplayName="SQL Server Management Studio" DownloadSize="45920256" PackageSize="45920256" InstalledSize="203197257" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_ssms_x64" RollbackLogPathVariable="WixBundleRollbackLog_sql_ssms_x64" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="sql_ssms_loc_x64_Loc" Vital="yes" DisplayName="SQL Server Management Studio" DownloadSize="1400832" PackageSize="1400832" InstalledSize="4774523" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_ssms_loc_x64_Loc" RollbackLogPathVariable="WixBundleRollbackLog_sql_ssms_loc_x64_Loc" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="ssms_rs_x64" Vital="yes" DisplayName="SQL Server Management Studio for Reporting Services" DownloadSize="8925184" PackageSize="8925184" InstalledSize="27438833" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_rs_x64" RollbackLogPathVariable="WixBundleRollbackLog_ssms_rs_x64" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="ssms_as_x64" Vital="yes" DisplayName="SQL Server Management Studio for Analysis Services" DownloadSize="82243584" PackageSize="82243584" InstalledSize="364561710" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_as_x64" RollbackLogPathVariable="WixBundleRollbackLog_ssms_as_x64" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="ssms_is" Vital="yes" DisplayName="Integration Services" DownloadSize="26750976" PackageSize="26750976" InstalledSize="92628121" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_is" RollbackLogPathVariable="WixBundleRollbackLog_ssms_is" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="AzureDataStudio" Vital="no" DisplayName="Azure Data Studio " Description="Azure Data Studio Setup " DownloadSize="104006760" PackageSize="104006760" InstalledSize="104006760" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_AzureDataStudio" RollbackLogPathVariable="WixBundleRollbackLog_AzureDataStudio" Compressed="yes" DisplayInternalUI="no" />
<WixPackageProperties Package="SsmsPostInstall_x64" Vital="yes" DisplayName="SSMS Post Install Tasks" DownloadSize="299008" PackageSize="299008" InstalledSize="0" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SsmsPostInstall_x64" RollbackLogPathVariable="WixBundleRollbackLog_SsmsPostInstall_x64" Compressed="yes" DisplayInternalUI="no" />
<WixPayloadProperties Payload="VCRedistD12x86" Package="VCRedistD12x86" Container="WixAttachedContainer" Name="2013\vcredist_x86.exe" Size="6503984" DownloadUrl="https://aka.ms/vs/15/release/vc_redist.x86.exe" LayoutOnly="no" />
<WixPayloadProperties Payload="VCRedistD14x86" Package="VCRedistD14x86" Container="WixAttachedContainer" Name="2017\VC_redist.x86.exe" Size="14673288" DownloadUrl="https://aka.ms/vs/15/release/vc_redist.x86.exe" LayoutOnly="no" />
<WixPayloadProperties Payload="VCRedistD14x64" Package="VCRedistD14x64" Container="WixAttachedContainer" Name="2017\VC_redist.x64.exe" Size="15354672" DownloadUrl="https://aka.ms/vs/15/release/vc_redist.x64.exe" LayoutOnly="no" />
<WixPayloadProperties Payload="HelpViewer2_3" Package="HelpViewer2_3" Container="WixAttachedContainer" Name="redist\help3_vs_net.msi" Size="311296" LayoutOnly="no" />
<WixPayloadProperties Payload="cabE503715EC9048140D7380B4A179097EF" Package="HelpViewer2_3" Container="WixAttachedContainer" Name="redist\cab1.cab" Size="2838296" LayoutOnly="no" />
<WixPayloadProperties Payload="DotNet47" Package="DotNet47" Container="WixAttachedContainer" Name="redist\NDP472-KB4054530-x86-x64-AllOS-ENU.exe" Size="83943272" LayoutOnly="no" />
<WixPayloadProperties Payload="NetFx45Web" Package="NetFx45Web" Name="redist\dotNetFx45_Full_setup.exe" Size="1005568" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=225704" LayoutOnly="no" />
<WixPayloadProperties Payload="sqlncli.msi" Package="sqlncli.msi" Container="WixAttachedContainer" Name="x64\sqlncli.msi" Size="5079040" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718112" LayoutOnly="no" />
<WixPayloadProperties Payload="msodbcsql.msi" Package="msodbcsql.msi" Container="WixAttachedContainer" Name="x64\msodbcsql.msi" Size="4640768" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718071" LayoutOnly="no" />
<WixPayloadProperties Payload="msoledbsql.msi" Package="msoledbsql.msi" Container="WixAttachedContainer" Name="x64\msoledbsql.msi" Size="7434240" LayoutOnly="no" />
<WixPayloadProperties Payload="sql_as_oledb_x64" Package="sql_as_oledb_x64" Container="WixAttachedContainer" Name="x64\sql_as_oledb.msi" Size="77770752" LayoutOnly="no" />
<WixPayloadProperties Payload="sql_as_oledb_x86" Package="sql_as_oledb_x86" Container="WixAttachedContainer" Name="x86\sql_as_oledb.msi" Size="38191104" LayoutOnly="no" />
<WixPayloadProperties Payload="VS2017IsoShellForSSMS" Package="VS2017IsoShellForSSMS" Container="WixAttachedContainer" Name="redist\vs2017_isoshell_for_ssms.msi" Size="142082048" LayoutOnly="no" />
<WixPayloadProperties Payload="VSTA2017" Package="VSTA2017" Container="WixAttachedContainer" Name="redist\vsta_setup.exe" Size="13395792" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=799679" LayoutOnly="no" />
<WixPayloadProperties Payload="sql_ssms_x64" Package="sql_ssms_x64" Container="WixAttachedContainer" Name="x64\sql_ssms.msi" Size="45920256" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718090" LayoutOnly="no" />
<WixPayloadProperties Payload="sql_ssms_loc_x64_Loc" Package="sql_ssms_loc_x64_Loc" Container="WixAttachedContainer" Name="x64\sql_ssms_loc.msi" Size="1400832" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718096" LayoutOnly="no" />
<WixPayloadProperties Payload="ssms_rs_x64" Package="ssms_rs_x64" Container="WixAttachedContainer" Name="x64\ssms_rs.msi" Size="8925184" LayoutOnly="no" />
<WixPayloadProperties Payload="ssms_as_x64" Package="ssms_as_x64" Container="WixAttachedContainer" Name="x64\ssms_as.msi" Size="82243584" LayoutOnly="no" />
<WixPayloadProperties Payload="ssms_is" Package="ssms_is" Container="WixAttachedContainer" Name="x86\ssms_is.msi" Size="26750976" LayoutOnly="no" />
<WixPayloadProperties Payload="AzureDataStudio" Package="AzureDataStudio" Container="WixAttachedContainer" Name="azuredatastudio-windows-setup.exe" Size="104006760" LayoutOnly="no" />
<WixPayloadProperties Payload="SsmsPostInstall_x64" Package="SsmsPostInstall_x64" Container="WixAttachedContainer" Name="x64\SsmsPostInstall.msi" Size="299008" LayoutOnly="no" />
<WixStdbaOverridableVariable Name="SSMSINSTALLROOT" />
<WixStdbaOverridableVariable Name="DONOTINSTALLAZUREDATASTUDIO" />
</BootstrapperApplicationData>
[3BD4:1448][2021-07-31T13:02:00]i000: MainViewModel.CheckFailedConditions: Check whether OS is Windows 10 / Windows Server 2016 pre-RS1 (build <= 10586). OSVersion = 10.0.19042
[3BD4:3280][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Caption: Microsoft Windows 10 Home
[3BD4:3280][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Version: 10.0.19042
[3BD4:3280][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: NetFx4 Version: 4.8.04084
[3BD4:3280][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS UI Culture: English (United States) (1033)
[3BD4:3280][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio InstallLocation: n/a
[3BD4:3280][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio DisplayVersion: n/a
[3BD4:3280][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio Version (Major.Minor): n/a
[3BD4:1448][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.SetCommandLineProperties: Begin
[3BD4:1448][2021-07-31T13:02:00]i000: ManagedBootstrapperApp.SetCommandLineProperties: End
[3BD4:1ED4][2021-07-31T13:02:02]i100: Detect begin, 20 packages
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'NETFRAMEWORK45' to value '528372'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall{6591F69E-6588-4980-81ED-C8FCBD7EC4B8}_is1'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'AzureDataStudioInstallExists' to value 0
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall{6748A5FD-29EB-4BA6-B3C6-E7B981B8D6B0}_is1'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'AzureDataStudioInstallExistsInsider' to value 0
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'AzureDataStudioInstallExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'AzureDataStudioInstallExistsInsider' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\SQL Server Management Studio\18'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'SSMS18PreReleaseDetected' to value 0
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'SSMSInstallExists' to value 0
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstallExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstallExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18\Language'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'SSMSInstalledLanguageKeyExists' to value 0
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition '(SSMSInstalledLanguage1028 = 1) OR (SSMSInstalledLanguage1031 = 1) OR (SSMSInstalledLanguage1033 = 1) OR (SSMSInstalledLanguage1036 = 1) OR (SSMSInstalledLanguage1040 = 1) OR (SSMSInstalledLanguage1041 = 1) OR (SSMSInstalledLanguage1042 = 1) OR (SSMSInstalledLanguage1046 = 1) OR (SSMSInstalledLanguage1049 = 1) OR (SSMSInstalledLanguage2052 = 1) OR (SSMSInstalledLanguage3082 = 1)' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\VisualStudio\12.0\VC\Runtimes\x86'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'VCRedist_D12x86_KeyExists' to value 0
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'VCRedist_D14x64_Bld' to value '29016'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'VCRedist_D14x64_KeyExists' to value 1
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'VCRedist_D14x64_Major' to value '14'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'VCRedist_D14x64_Minor' to value '27'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'VCRedist_D14x86_Bld' to value '26429'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting numeric variable 'VCRedist_D14x86_KeyExists' to value 1
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'VCRedist_D14x86_Major' to value '14'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'VCRedist_D14x86_Minor' to value '14'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'HKLM\Software\Microsoft\DevDiv\vsta\Servicing\15.0\hosting'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Package_for_KB2919355~31bf3856ad364e35~amd64~~6.3.1.14'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'Netfx4FullReleaseX64' to value '528372'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'InstallationType' to value 'Client'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Setting string variable 'Netfx4ClientReleaseX64' to value '528372'
[3BD4:1ED4][2021-07-31T13:02:02]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Package_for_KB2919355~31bf3856ad364e35~x86~~6.3.1.14'
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'VCRedist_D12x86_KeyExists' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'VCRedist_D14x86_KeyExists AND (VCRedist_D14x86_Major >= 14) AND (VCRedist_D14x86_Minor >= 10) AND (VCRedist_D14x86_Bld >= 25008)' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'VCRedist_D14x64_KeyExists AND (VCRedist_D14x64_Major >= 14) AND (VCRedist_D14x64_Minor >= 10) AND (VCRedist_D14x64_Bld >= 25008)' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]w120: Detected partially cached package: HelpViewer2_3, invalid payload: HelpViewer2_3, reason: 0x80070570
[3BD4:1ED4][2021-07-31T13:02:02]w120: Detected partially cached package: HelpViewer2_3, invalid payload: cabE503715EC9048140D7380B4A179097EF, reason: 0x80070570
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition '(Netfx4FullReleaseX64 >= 461808) OR (NetFx4ClientReleaseX64 >= 461808)' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'NETFRAMEWORK45 >= 378389' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i103: Detected related package: {787F8536-654C-4DD4-AD3F-22B529F8F339}, scope: PerMachine, version: 17.4.0.1, language: 0 operation: MajorUpgrade
[3BD4:1ED4][2021-07-31T13:02:02]i103: Detected related package: {9AA0AFFA-EDB6-4B66-9FD7-BBC828D88B47}, scope: PerMachine, version: 18.2.3.0, language: 0 operation: MajorUpgrade
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'VSTA2017Installed' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition '(DONOTINSTALLAZUREDATASTUDIO = 1) OR (AzureDataStudioInstalledVersion >= v1.27.0) OR (AzureDataStudioInstalledVersionInsider >= v1.27.0)' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: VCRedistD12x86, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: VCRedistD14x86, state: Present, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: VCRedistD14x64, state: Present, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: HelpViewer2_3, state: Absent, cached: Partial
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: DotNet47, state: Present, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: NetFx45Web, state: Present, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: sqlncli.msi, state: Present, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: msodbcsql.msi, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: msoledbsql.msi, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: sql_as_oledb_x64, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: sql_as_oledb_x86, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: VS2017IsoShellForSSMS, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: VSTA2017, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: sql_ssms_x64, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: sql_ssms_loc_x64_Loc, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: ssms_rs_x64, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: ssms_as_x64, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: ssms_is, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: AzureDataStudio, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i101: Detected package: SsmsPostInstall_x64, state: Absent, cached: None
[3BD4:1ED4][2021-07-31T13:02:02]i000: BootstrapperEngineDataModel.OnDetectComplete.: Entering...
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel: Trying to parse value '0' for property 'SSMSInstallExists'...
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.CheckInstallPathIsValid: Successfully created and deleted installation folder - 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18'
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: IsUpgradeScenario=False
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: SSMSInstallRoot=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: SSMSInstallVersion=none
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel: Trying to parse value '0' for property 'AzureDataStudioInstallExists'...
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstallExists=False
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstalledVersion=
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel: Trying to parse value '0' for property 'AzureDataStudioInstallExistsInsider'...
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstallExistsInsider=False
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstalledVersionInsider=
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioVersion=1.27.0
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel: Trying to parse value '0' for property 'DONOTINSTALLAZUREDATASTUDIO'...
[3BD4:1ED4][2021-07-31T13:02:02]i000: MainViewModel.OnBootstrapperReady: DONOTINSTALLAZUREDATASTUDIO=False
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'RebootPending = 1' evaluates to false.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'SSMS18PreReleaseDetected = 0' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition '(SSMS18PreReleaseDetected = 1) OR (SSMSInstallExists = 0) OR (SSMSInstalledLanguageKeyExists = 0) OR SSMSInstalledLanguageMatch' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'NOT Msix64' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'RebootPending = 0' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition '(VersionNT = v6.1 AND ServicePackLevel = 1) OR VersionNT > v6.1' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition 'Installed OR (VersionNT <> v6.2) OR (InstallationType <> "Client")' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i052: Condition '(VersionNT <> v6.3) OR (KB2919355_amd64_CurrentState = 112 OR KB2919355_x86_CurrentState = 112)' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:02]i000: BootstrapperEngineDataModel.OnDetectComplete.: Exiting.
[3BD4:1ED4][2021-07-31T13:02:02]i199: Detect complete, result: 0x0
[3BD4:1448][2021-07-31T13:02:11]i000: Setting string variable 'SSMSINSTALLROOT' to value 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18'
[3BD4:1448][2021-07-31T13:02:11]i000: MainViewModel.CheckInstallPathIsValid: Successfully created and deleted installation folder - 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18'
[3BD4:1448][2021-07-31T13:02:11]i000: MainViewModel.Install: Install action clicked
[3BD4:1ED4][2021-07-31T13:02:11]i200: Plan begin, 20 packages, action: Install
[3BD4:1ED4][2021-07-31T13:02:11]w321: Skipping dependency registration on package with no dependency providers: VCRedistD12x86
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_VCRedistD12x86' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_0_VCRedistD12x86.log'
[3BD4:1ED4][2021-07-31T13:02:11]w321: Skipping dependency registration on package with no dependency providers: VCRedistD14x86
[3BD4:1ED4][2021-07-31T13:02:11]w321: Skipping dependency registration on package with no dependency providers: VCRedistD14x64
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_HelpViewer2_3' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_1_HelpViewer2_3_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_HelpViewer2_3' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_1_HelpViewer2_3.log'
[3BD4:1ED4][2021-07-31T13:02:11]w321: Skipping dependency registration on package with no dependency providers: DotNet47
[3BD4:1ED4][2021-07-31T13:02:11]w321: Skipping dependency registration on package with no dependency providers: NetFx45Web
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_msodbcsql.msi' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_2_msodbcsql.msi.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_msoledbsql.msi' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_3_msoledbsql.msi.log'
[3BD4:1ED4][2021-07-31T13:02:11]i052: Condition 'VersionNT64' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_sql_as_oledb_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_4_sql_as_oledb_x64_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_sql_as_oledb_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_4_sql_as_oledb_x64.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_sql_as_oledb_x86' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_5_sql_as_oledb_x86_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_sql_as_oledb_x86' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_5_sql_as_oledb_x86.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_VS2017IsoShellForSSMS' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_6_VS2017IsoShellForSSMS_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_VS2017IsoShellForSSMS' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_6_VS2017IsoShellForSSMS.log'
[3BD4:1ED4][2021-07-31T13:02:11]w321: Skipping dependency registration on package with no dependency providers: VSTA2017
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_VSTA2017' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_7_VSTA2017.log'
[3BD4:1ED4][2021-07-31T13:02:11]i052: Condition 'VersionNT64' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_sql_ssms_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_8_sql_ssms_x64_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_sql_ssms_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_8_sql_ssms_x64.log'
[3BD4:1ED4][2021-07-31T13:02:11]i052: Condition 'VersionNT64' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_sql_ssms_loc_x64_Loc' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_9_sql_ssms_loc_x64_Loc_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_sql_ssms_loc_x64_Loc' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_9_sql_ssms_loc_x64_Loc.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_ssms_rs_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_10_ssms_rs_x64_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_ssms_rs_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_10_ssms_rs_x64.log'
[3BD4:1ED4][2021-07-31T13:02:11]i052: Condition 'VersionNT64' evaluates to true.
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_ssms_as_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_11_ssms_as_x64_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_ssms_as_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_11_ssms_as_x64.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_ssms_is' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_12_ssms_is_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_ssms_is' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_12_ssms_is.log'
[3BD4:1ED4][2021-07-31T13:02:11]w321: Skipping dependency registration on package with no dependency providers: AzureDataStudio
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_AzureDataStudio' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_13_AzureDataStudio.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleRollbackLog_SsmsPostInstall_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_14_SsmsPostInstall_x64_rollback.log'
[3BD4:1ED4][2021-07-31T13:02:11]i000: Setting string variable 'WixBundleLog_SsmsPostInstall_x64' to value 'C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149_14_SsmsPostInstall_x64.log'
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: VCRedistD12x86, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: None
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: VCRedistD14x86, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: VCRedistD14x64, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: HelpViewer2_3, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: DotNet47, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: NetFx45Web, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: sqlncli.msi, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: msodbcsql.msi, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: msoledbsql.msi, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: sql_as_oledb_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: sql_as_oledb_x86, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: VS2017IsoShellForSSMS, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: VSTA2017, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: None
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: sql_ssms_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: sql_ssms_loc_x64_Loc, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: ssms_rs_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: ssms_as_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: ssms_is, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: AzureDataStudio, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: None
[3BD4:1ED4][2021-07-31T13:02:11]i201: Planned package: SsmsPostInstall_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[3BD4:1ED4][2021-07-31T13:02:11]i299: Plan complete, result: 0x0
[3BD4:1ED4][2021-07-31T13:02:11]i300: Apply begin
[3BD4:1ED4][2021-07-31T13:02:11]i000: MainViewModel.OnBundleAction: Bundle action started
[2468:27E4][2021-07-31T13:02:11]i360: Creating a system restore point.
[2468:27E4][2021-07-31T13:02:11]w363: Could not create system restore point, error: 0x80070422. Continuing...
[2468:27E4][2021-07-31T13:02:11]i000: Caching bundle from: 'C:\Users\Vadym\AppData\Local\Temp{9d5158d0-90da-41c5-823a-93973caaf861}.be\SSMS-Setup-ENU.exe' to: 'C:\ProgramData\Package Cache{9d5158d0-90da-41c5-823a-93973caaf861}\SSMS-Setup-ENU.exe'
[2468:27E4][2021-07-31T13:02:11]i320: Registering bundle dependency provider: {9d5158d0-90da-41c5-823a-93973caaf861}, version: 15.0.18382.0
[2468:427C][2021-07-31T13:02:20]i305: Verified acquired payload: VCRedistD12x86 at path: C:\ProgramData\Package Cache.unverified\VCRedistD12x86, moving to: C:\ProgramData\Package Cache\DF7F0A73BFA077E483E51BFB97F5E2ECEEDFB6A3\2013\vcredist_x86.exe.
[2468:427C][2021-07-31T13:02:21]e000: Error 0x800b010c: Failed authenticode verification of payload: C:\ProgramData\Package Cache.unverified\HelpViewer2_3
[2468:427C][2021-07-31T13:02:21]e000: Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3
[2468:427C][2021-07-31T13:02:21]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache.unverified\HelpViewer2_3, error: 0x800b010c. Deleting file.
[2468:427C][2021-07-31T13:02:21]e000: Error 0x800b010c: Failed to cache payload: HelpViewer2_3
[3BD4:03DC][2021-07-31T13:02:21]e314: Failed to cache payload: HelpViewer2_3 from working path: C:\Users\Vadym\AppData\Local\Temp{9d5158d0-90da-41c5-823a-93973caaf861}\HelpViewer2_3, error: 0x800b010c.
[3BD4:03DC][2021-07-31T13:02:21]e349: Application requested retry of payload: HelpViewer2_3, encountered error: 0x800b010c. Retrying...
[2468:427C][2021-07-31T13:02:24]e000: Error 0x800b010c: Failed authenticode verification of payload: C:\ProgramData\Package Cache.unverified\HelpViewer2_3
[2468:427C][2021-07-31T13:02:24]e000: Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3
[2468:427C][2021-07-31T13:02:24]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache.unverified\HelpViewer2_3, error: 0x800b010c. Deleting file.
[2468:427C][2021-07-31T13:02:24]e000: Error 0x800b010c: Failed to cache payload: HelpViewer2_3
[3BD4:03DC][2021-07-31T13:02:24]e314: Failed to cache payload: HelpViewer2_3 from working path: C:\Users\Vadym\AppData\Local\Temp{9d5158d0-90da-41c5-823a-93973caaf861}\HelpViewer2_3, error: 0x800b010c.
[3BD4:03DC][2021-07-31T13:02:24]e349: Application requested retry of payload: HelpViewer2_3, encountered error: 0x800b010c. Retrying...
[2468:427C][2021-07-31T13:02:28]e000: Error 0x800b010c: Failed authenticode verification of payload: C:\ProgramData\Package Cache.unverified\HelpViewer2_3
[2468:427C][2021-07-31T13:02:28]e000: Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3
[2468:427C][2021-07-31T13:02:28]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache.unverified\HelpViewer2_3, error: 0x800b010c. Deleting file.
[2468:427C][2021-07-31T13:02:28]e000: Error 0x800b010c: Failed to cache payload: HelpViewer2_3
[3BD4:03DC][2021-07-31T13:02:28]e314: Failed to cache payload: HelpViewer2_3 from working path: C:\Users\Vadym\AppData\Local\Temp{9d5158d0-90da-41c5-823a-93973caaf861}\HelpViewer2_3, error: 0x800b010c.
[2468:427C][2021-07-31T13:02:28]i351: Removing cached package: VCRedistD12x86, from path: C:\ProgramData\Package Cache\DF7F0A73BFA077E483E51BFB97F5E2ECEEDFB6A3\
[3BD4:1ED4][2021-07-31T13:02:28]e000: Error 0x800b010c: Failed while caching, aborting execution.
[2468:27E4][2021-07-31T13:02:28]i330: Removed bundle dependency provider: {9d5158d0-90da-41c5-823a-93973caaf861}
[2468:27E4][2021-07-31T13:02:28]i352: Removing cached bundle: {9d5158d0-90da-41c5-823a-93973caaf861}, from path: C:\ProgramData\Package Cache{9d5158d0-90da-41c5-823a-93973caaf861}\
[3BD4:1ED4][2021-07-31T13:02:28]e000: MainViewModel.OnBundleAction: Bundle action failed: A certificate was explicitly revoked by its issuer (0x800B010C)
[3BD4:1ED4][2021-07-31T13:02:28]i399: Apply complete, result: 0x800b010c, restart: None, ba requested restart: No
[3BD4:1448][2021-07-31T13:08:48]i000: MainViewModel.OpenUrl: Opening url: C:\Users\Vadym\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210731130149.log

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi 11717922,
Welcome to Microsoft Q&A.

This issue is caused by badly signed packages in the SSMS installer, and is also related to the HelpViewer 2.3 component.
Please refer to this workaround from this similar thread which might help:

Using Certificate Manager I backed up and then completely emptied the following (Local Computer) physical stores: Trusted Root Certification Authorities (Registry), Trusted Root Certification Authorities (Third-Party) and Untrusted Certificates (Registry). I then installed all the certificates I found in the file (noted above) into the Trusted Root Certification Authorities (Registry). I then conducted an iterative process of running the SSMS-Setup-ENU installation. As each iteration failed I gathered more certificates from files causing authenticode issues. Eventually I was able to get a successful install. I then exported the Trusted Root Certification Authorities (Third-Party) as a Microsoft Serialized Certificate Store. I have posted this file online and shared it at the following link: https://app.box.com/s/zlxo6g58ntkc02yvtbq3o18k9tgcgenx.

Forward to release 18.9.2 (from the previously noted site). It also fails to install. I emptied the stores (noted above) and imported the Microsoft Serialized Certificate Store file I had exported in the successful 18.9.1 installation. I then re-ran the 18.9.2 installation package and the upgrade was successful. The SHA256 for this file is 03e567b7475ec2e2da237d70e9a833deabf52ca66d521f340a1ebc8fdea91170 (in case the download mysteriously changes as it did for the 18.9.1 release).

I recommend you submit it to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server.
Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.