question

GlennBurkins-0100 avatar image
1 Vote"
GlennBurkins-0100 asked MarcoZimmermann-2191 published

Issue upgrading/installing SSMS.

I had been running SSMS 18.8 since late last year on two different development machines. Early in April of this year I encountered an issue on one machine which caused me to rerun the SSMS Setup package and take the option to repair the installation. The repair came back with a message along the lines of “a certificate was explicitly revoked...” or “..authication failure...”, I didn’t record the specific error. So, I started to investigate. I looked at the installation package properties under the Digital Signatures tab and viewed the certificate associated with the package. The certificate was valid from 3/4/2020 to 3/3/2021. As this was early April I reasoned there might be a correlation here. Now this seems odd to me as this would indicate that installation packages would have a limited shelf life (so to speak).

Forward to April 16. I found MS issued SSMS 18.9. I reasoned this would surely solve my problem so I downloaded the bits and ran the installation. To my surprise – the same error. I then became suspicious of what remained of my installed SSMS so I uninstalled it completely.

Forward to April 19. I found MS issued SSMS 18.9.1. I hoped that MS had discovered a problem with the previous package and was offering me a solution! Alas, it was not to be.

At this point in time I tried to eliminate any barriers to getting valid authenticode verification. I disabled my firewall completely and emptied my certificate stores (all of them) reasoning that the installation package would use the internet for verification. I ran the SSMS 18.9.1 installer. It failed again.

I am running Windows 10 Pro - OS build 19042.928. The system runs cleanly as I am parochial...

The message appearing on the installation interface states: "A certificate was explicitly revoked by its issuer (0x800B010C)" Here is the log file associated with this failed install:

[1EE0:1EA8][2021-04-26T15:06:45]i001: Burn v3.8.1128.0, Windows v6.3 (Build 9600: Service Pack 0), path: D:\downloads\~microsoft\SQL Server\SQL Server Management Studio\SSMS-Setup-ENU-18_9_1.exe, cmdline: '-burn.unelevated BurnPipe.{0F393202-8C36-402A-9265-1D8D4A75A7A6} {2EDD1BC9-B7AD-4248-B356-B996D28B16D1} 7928'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SSMSINSTALLROOT' to value '[ProgramFilesFolder]Microsoft SQL Server Management Studio 18'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing numeric variable 'SSMSInstallExists' to value '0'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SSMSInstalledLanguageKeyExists' to value 'false'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SSMSInstalledLanguageMatch' to value 'true'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SSMS18PreReleaseDetected' to value 'false'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SSMS18InstalledVersion' to value ''
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'AzureDataStudioInstalledVersion' to value ''
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'AzureDataStudioInstalledVersionInsider' to value ''
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing numeric variable 'AzureDataStudioInstallExists' to value '0'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing numeric variable 'AzureDataStudioInstallExistsInsider' to value '0'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'AzureDataStudioVersion' to value '1.28.0'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing numeric variable 'DONOTINSTALLAZUREDATASTUDIO' to value '0'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'ProductVersionVar' to value '15.0.18384.0'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'HeaderText' to value 'Release 18.9.1'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SubHeaderText' to value 'Microsoft SQL Server Management Studio with Azure Data Studio'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'LicenseTermsSSMSUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x[System.Convert]::ToInt32(1033)'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'LicenseTermsADSUrl' to value 'https://go.microsoft.com/fwlink/?linkid=2140322&clcid=0x[System.Convert]::ToInt32(1033)'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'PreviewStatementUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=824140'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'TelemetryDocumentationUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=869476'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing numeric variable 'InstallerLcid' to value '1033'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'CancelText' to value 'C_ancel'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'CloseText' to value '_Close'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'ContinuePastWarningText' to value 'Do you wish to continue?'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'InstallText' to value '_Install'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'LicenseTermsSSMSText' to value 'SQL Server Management Studio'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'LicenseTermsADSText' to value 'Azure Data Studio'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'LoadingPackagesText' to value 'Loading packages. Please wait...'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'OverallProgressText' to value 'Overall Progress'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'PackageProgressText' to value 'Package Progress'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'PrivacyStatementText' to value 'Privacy Statement'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'TelemetryDocumentationText' to value 'documentation'
[1EE0:1EA8][2021-04-26T15:06:45]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}.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'RepairText' to value 'Repair'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'RestartText' to value 'Restart'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupBlockedDescriptionText' to value 'Something has blocked setup from continuing.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupBlockedText' to value 'Setup Blocked'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupCanceledDescriptionText' to value 'The setup operation has been canceled.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupCanceledText' to value 'Setup Canceled'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupCompletedText' to value 'Setup Completed'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupFailedDescriptionText' to value 'A failure occured during installation.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupFailedText' to value 'Setup Failed'
[1EE0:1EA8][2021-04-26T15:06:45]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}.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupHelpText' to value 'Setup Help'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupInstalledText' to value 'All specified components have been installed successfully.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupLayoutText' to value 'Layout operation has completed.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupLogText' to value 'Click here for the log file.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupProgressText' to value 'Setup Progress'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupRepairedText' to value 'All specified components have been repaired successfully.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupRestartDescriptionText' to value 'The computer needs to be restarted before setup can continue.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupRestartText' to value 'Restart required in order to complete setup.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupUninstalledText' to value 'All specified components have been uninstalled successfully.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupWarningDescriptionText' to value 'The following issues may impact the installed application.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SetupWarningText' to value 'Setup Warnings'
[1EE0:1EA8][2021-04-26T15:06:45]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}.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'UninstallText' to value 'Uninstall'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'WelcomeInstallText' to value 'Welcome. Click "Install" to begin.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'YesText' to value 'Yes'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'RestartAlreadyPending' to value 'A pending restart is blocking setup from completing. Please restart the computer and run setup again.'
[1EE0:1EA8][2021-04-26T15:06:45]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.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'SSMSCurrentlyRunning' to value 'SSMS is currently running. Please close any open instances of SSMS and run this installer again.'
[1EE0:1EA8][2021-04-26T15:06:45]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.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'MinimizeButtonAccessibleName' to value 'Minimize'
[1EE0:1EA8][2021-04-26T15:06:45]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.'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'IsUpgradeScenario' to value 'false'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'ChangeText' to value 'C_hange'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'LocationText' to value '_Location:'
[1EE0:1EA8][2021-04-26T15:06:45]i000: Initializing string variable 'InvalidLocationText' to value 'Invalid location. Please enter a valid location to proceed.'
[1EE0:1EA8][2021-04-26T15:06:46]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646.log'
[1EE0:1EA8][2021-04-26T15:06:46]i000: Setting string variable 'WixBundleOriginalSource' to value 'D:\downloads\~microsoft\SQL Server\SQL Server Management Studio\SSMS-Setup-ENU-18_9_1.exe'
[1EE0:1EA8][2021-04-26T15:06:46]i000: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Management Studio - 18.9.1'
[1EE0:1EA8][2021-04-26T15:06:47]i000: Loading managed bootstrapper application.
[1EE0:1EA8][2021-04-26T15:06:50]i000: Creating BA thread to run asynchronously.
[1EE0:04CC][2021-04-26T15:06:54]i000: ManagedBootstrapperApp.Run: Launching the managed bootstrapper application.
[1EE0:04CC][2021-04-26T15:06:54]i000: BootstrapperMetadataModel.Initialize: Start loading the bootstrapper app data xml file
[1EE0:04CC][2021-04-26T15:06:55]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.1" LogPathVariable="WixBundleLog" Compressed="no" Id="{bf0d55ea-f272-49bc-8699-22fbdcc115a8}" 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="45924352" PackageSize="45924352" InstalledSize="203200849" 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="1404928" PackageSize="1404928" InstalledSize="4774395" 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="103931136" PackageSize="103931136" InstalledSize="103931136" 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="45924352" 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="1404928" 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="103931136" 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>
[1EE0:0860][2021-04-26T15:06:57]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Caption: Microsoft Windows 10 Pro
[1EE0:0860][2021-04-26T15:06:57]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Version: 10.0.19042
[1EE0:0860][2021-04-26T15:06:57]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: NetFx4 Version: 4.8.04084
[1EE0:0860][2021-04-26T15:06:57]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS UI Culture: English (United States) (1033)
[1EE0:0860][2021-04-26T15:06:57]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio InstallLocation: n/a
[1EE0:0860][2021-04-26T15:06:57]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio DisplayVersion: n/a
[1EE0:0860][2021-04-26T15:06:57]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio Version (Major.Minor): n/a
[1EE0:04CC][2021-04-26T15:07:01]i000: MainViewModel.CheckFailedConditions: Check whether OS is Windows 10 / Windows Server 2016 pre-RS1 (build <= 10586). OSVersion = 10.0.19042
[1EE0:04CC][2021-04-26T15:07:01]i000: ManagedBootstrapperApp.SetCommandLineProperties: Begin
[1EE0:04CC][2021-04-26T15:07:01]i000: ManagedBootstrapperApp.SetCommandLineProperties: End
[1EE0:1EA8][2021-04-26T15:07:08]i100: Detect begin, 20 packages
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'NETFRAMEWORK45' to value '528372'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall{6591F69E-6588-4980-81ED-C8FCBD7EC4B8}_is1'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'AzureDataStudioInstallExists' to value 0
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall{6748A5FD-29EB-4BA6-B3C6-E7B981B8D6B0}_is1'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'AzureDataStudioInstallExistsInsider' to value 0
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'AzureDataStudioInstallExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'AzureDataStudioInstallExistsInsider' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\SQL Server Management Studio\18'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'SSMS18PreReleaseDetected' to value 0
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'SSMSInstallExists' to value 0
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstallExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstallExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18\Language'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'SSMSInstalledLanguageKeyExists' to value 0
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:08]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.
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'VCRedist_D12x86_KeyExists' to value 1
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'VCRedist_D14x64_Bld' to value '29301'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'VCRedist_D14x64_KeyExists' to value 1
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'VCRedist_D14x64_Major' to value '14'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'VCRedist_D14x64_Minor' to value '28'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'VCRedist_D14x86_Bld' to value '29301'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting numeric variable 'VCRedist_D14x86_KeyExists' to value 1
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'VCRedist_D14x86_Major' to value '14'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'VCRedist_D14x86_Minor' to value '28'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'HKLM\Software\Microsoft\DevDiv\vsta\Servicing\15.0\hosting'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Package_for_KB2919355~31bf3856ad364e35~amd64~~6.3.1.14'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'Netfx4FullReleaseX64' to value '528372'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'InstallationType' to value 'Client'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Setting string variable 'Netfx4ClientReleaseX64' to value '528372'
[1EE0:1EA8][2021-04-26T15:07:08]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Package_for_KB2919355~31bf3856ad364e35~x86~~6.3.1.14'
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'VCRedist_D12x86_KeyExists' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'VCRedist_D14x86_KeyExists AND (VCRedist_D14x86_Major >= 14) AND (VCRedist_D14x86_Minor >= 10) AND (VCRedist_D14x86_Bld >= 25008)' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:08]i052: Condition 'VCRedist_D14x64_KeyExists AND (VCRedist_D14x64_Major >= 14) AND (VCRedist_D14x64_Minor >= 10) AND (VCRedist_D14x64_Bld >= 25008)' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]w120: Detected partially cached package: HelpViewer2_3, invalid payload: HelpViewer2_3, reason: 0x80070570
[1EE0:1EA8][2021-04-26T15:07:09]w120: Detected partially cached package: HelpViewer2_3, invalid payload: cabE503715EC9048140D7380B4A179097EF, reason: 0x80070570
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition '(Netfx4FullReleaseX64 >= 461808) OR (NetFx4ClientReleaseX64 >= 461808)' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition 'NETFRAMEWORK45 >= 378389' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i103: Detected related package: {6BF11ECE-3CE8-4FBA-991A-1F55AA6BE5BF}, scope: PerMachine, version: 15.0.1300.359, language: 0 operation: MajorUpgrade
[1EE0:1EA8][2021-04-26T15:07:09]i103: Detected related package: {6BF11ECE-3CE8-4FBA-991A-1F55AA6BE5BF}, scope: PerMachine, version: 15.0.1300.359, language: 0 operation: MajorUpgrade
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition 'VSTA2017Installed' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition '(DONOTINSTALLAZUREDATASTUDIO = 1) OR (AzureDataStudioInstalledVersion >= v1.28.0) OR (AzureDataStudioInstalledVersionInsider >= v1.28.0)' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: VCRedistD12x86, state: Present, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: VCRedistD14x86, state: Present, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: VCRedistD14x64, state: Present, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: HelpViewer2_3, state: Absent, cached: Partial
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: DotNet47, state: Present, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: NetFx45Web, state: Present, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: sqlncli.msi, state: Present, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: msodbcsql.msi, state: Present, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: msoledbsql.msi, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: sql_as_oledb_x64, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: sql_as_oledb_x86, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: VS2017IsoShellForSSMS, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: VSTA2017, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: sql_ssms_x64, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: sql_ssms_loc_x64_Loc, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: ssms_rs_x64, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: ssms_as_x64, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: ssms_is, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: AzureDataStudio, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i101: Detected package: SsmsPostInstall_x64, state: Absent, cached: None
[1EE0:1EA8][2021-04-26T15:07:09]i000: BootstrapperEngineDataModel.OnDetectComplete.: Entering...
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel: Trying to parse value '0' for property 'SSMSInstallExists'...
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.CheckInstallPathIsValid: Successfully created and deleted installation folder - 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18'
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: IsUpgradeScenario=False
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: SSMSInstallRoot=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: SSMSInstallVersion=none
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel: Trying to parse value '0' for property 'AzureDataStudioInstallExists'...
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstallExists=False
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstalledVersion=
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel: Trying to parse value '0' for property 'AzureDataStudioInstallExistsInsider'...
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstallExistsInsider=False
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioInstalledVersionInsider=
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: AzureDataStudioVersion=1.28.0
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel: Trying to parse value '0' for property 'DONOTINSTALLAZUREDATASTUDIO'...
[1EE0:1EA8][2021-04-26T15:07:09]i000: MainViewModel.OnBootstrapperReady: DONOTINSTALLAZUREDATASTUDIO=False
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition 'RebootPending = 1' evaluates to false.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition 'SSMS18PreReleaseDetected = 0' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition '(SSMS18PreReleaseDetected = 1) OR (SSMSInstallExists = 0) OR (SSMSInstalledLanguageKeyExists = 0) OR SSMSInstalledLanguageMatch' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition 'NOT Msix64' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition 'RebootPending = 0' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition '(VersionNT = v6.1 AND ServicePackLevel = 1) OR VersionNT > v6.1' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition 'Installed OR (VersionNT <> v6.2) OR (InstallationType <> "Client")' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i052: Condition '(VersionNT <> v6.3) OR (KB2919355_amd64_CurrentState = 112 OR KB2919355_x86_CurrentState = 112)' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:09]i000: BootstrapperEngineDataModel.OnDetectComplete.: Exiting.
[1EE0:1EA8][2021-04-26T15:07:09]i199: Detect complete, result: 0x0
[1EE0:04CC][2021-04-26T15:07:58]i000: Setting string variable 'SSMSINSTALLROOT' to value 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18'
[1EE0:04CC][2021-04-26T15:07:58]i000: MainViewModel.CheckInstallPathIsValid: Successfully created and deleted installation folder - 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18'
[1EE0:04CC][2021-04-26T15:07:58]i000: MainViewModel.Install: Install action clicked
[1EE0:1EA8][2021-04-26T15:07:58]i200: Plan begin, 20 packages, action: Install
[1EE0:1EA8][2021-04-26T15:07:58]w321: Skipping dependency registration on package with no dependency providers: VCRedistD12x86
[1EE0:1EA8][2021-04-26T15:07:58]w321: Skipping dependency registration on package with no dependency providers: VCRedistD14x86
[1EE0:1EA8][2021-04-26T15:07:58]w321: Skipping dependency registration on package with no dependency providers: VCRedistD14x64
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_HelpViewer2_3' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_0_HelpViewer2_3_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_HelpViewer2_3' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_0_HelpViewer2_3.log'
[1EE0:1EA8][2021-04-26T15:07:58]w321: Skipping dependency registration on package with no dependency providers: DotNet47
[1EE0:1EA8][2021-04-26T15:07:58]w321: Skipping dependency registration on package with no dependency providers: NetFx45Web
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_msoledbsql.msi' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_1_msoledbsql.msi.log'
[1EE0:1EA8][2021-04-26T15:07:58]i052: Condition 'VersionNT64' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_sql_as_oledb_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_2_sql_as_oledb_x64_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_sql_as_oledb_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_2_sql_as_oledb_x64.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_sql_as_oledb_x86' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_3_sql_as_oledb_x86_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_sql_as_oledb_x86' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_3_sql_as_oledb_x86.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_VS2017IsoShellForSSMS' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_4_VS2017IsoShellForSSMS_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_VS2017IsoShellForSSMS' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_4_VS2017IsoShellForSSMS.log'
[1EE0:1EA8][2021-04-26T15:07:58]w321: Skipping dependency registration on package with no dependency providers: VSTA2017
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_VSTA2017' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_5_VSTA2017.log'
[1EE0:1EA8][2021-04-26T15:07:58]i052: Condition 'VersionNT64' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_sql_ssms_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_6_sql_ssms_x64_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_sql_ssms_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_6_sql_ssms_x64.log'
[1EE0:1EA8][2021-04-26T15:07:58]i052: Condition 'VersionNT64' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_sql_ssms_loc_x64_Loc' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_7_sql_ssms_loc_x64_Loc_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_sql_ssms_loc_x64_Loc' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_7_sql_ssms_loc_x64_Loc.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_ssms_rs_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_8_ssms_rs_x64_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_ssms_rs_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_8_ssms_rs_x64.log'
[1EE0:1EA8][2021-04-26T15:07:58]i052: Condition 'VersionNT64' evaluates to true.
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_ssms_as_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_9_ssms_as_x64_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_ssms_as_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_9_ssms_as_x64.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_ssms_is' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_10_ssms_is_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_ssms_is' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_10_ssms_is.log'
[1EE0:1EA8][2021-04-26T15:07:58]w321: Skipping dependency registration on package with no dependency providers: AzureDataStudio
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_AzureDataStudio' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_11_AzureDataStudio.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleRollbackLog_SsmsPostInstall_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_12_SsmsPostInstall_x64_rollback.log'
[1EE0:1EA8][2021-04-26T15:07:58]i000: Setting string variable 'WixBundleLog_SsmsPostInstall_x64' to value 'C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_12_SsmsPostInstall_x64.log'
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: VCRedistD12x86, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: VCRedistD14x86, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: VCRedistD14x64, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: HelpViewer2_3, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: DotNet47, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: NetFx45Web, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: sqlncli.msi, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: msodbcsql.msi, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: msoledbsql.msi, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]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
[1EE0:1EA8][2021-04-26T15:07:58]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
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: VS2017IsoShellForSSMS, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: VSTA2017, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: None
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: sql_ssms_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]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
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: ssms_rs_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: ssms_as_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: ssms_is, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: AzureDataStudio, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: None
[1EE0:1EA8][2021-04-26T15:07:58]i201: Planned package: SsmsPostInstall_x64, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[1EE0:1EA8][2021-04-26T15:07:58]i299: Plan complete, result: 0x0
[1EE0:1EA8][2021-04-26T15:07:58]i300: Apply begin
[1EE0:1EA8][2021-04-26T15:07:58]i000: MainViewModel.OnBundleAction: Bundle action started
[1EF8:1F0C][2021-04-26T15:07:58]i360: Creating a system restore point.
[1EF8:1F0C][2021-04-26T15:07:58]w363: Could not create system restore point, error: 0x80070422. Continuing...
[1EF8:1F0C][2021-04-26T15:07:58]i000: Caching bundle from: 'C:\Users\GLENNB~1\AppData\Local\Temp{bf0d55ea-f272-49bc-8699-22fbdcc115a8}.be\SSMS-Setup-ENU.exe' to: 'C:\ProgramData\Package Cache{bf0d55ea-f272-49bc-8699-22fbdcc115a8}\SSMS-Setup-ENU.exe'
[1EF8:1F0C][2021-04-26T15:07:59]i320: Registering bundle dependency provider: {bf0d55ea-f272-49bc-8699-22fbdcc115a8}, version: 15.0.18384.0
[1EF8:168C][2021-04-26T15:08:28]e000: Error 0x800b010c: Failed authenticode verification of payload: C:\ProgramData\Package Cache.unverified\HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:28]e000: Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:28]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache.unverified\HelpViewer2_3, error: 0x800b010c. Deleting file.
[1EF8:168C][2021-04-26T15:08:28]e000: Error 0x800b010c: Failed to cache payload: HelpViewer2_3
[1EE0:1918][2021-04-26T15:08:28]e314: Failed to cache payload: HelpViewer2_3 from working path: C:\Users\GLENNB~1\AppData\Local\Temp{bf0d55ea-f272-49bc-8699-22fbdcc115a8}\HelpViewer2_3, error: 0x800b010c.
[1EE0:1918][2021-04-26T15:08:28]e349: Application requested retry of payload: HelpViewer2_3, encountered error: 0x800b010c. Retrying...
[1EF8:168C][2021-04-26T15:08:39]e000: Error 0x800b010c: Failed authenticode verification of payload: C:\ProgramData\Package Cache.unverified\HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:39]e000: Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:39]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache.unverified\HelpViewer2_3, error: 0x800b010c. Deleting file.
[1EF8:168C][2021-04-26T15:08:39]e000: Error 0x800b010c: Failed to cache payload: HelpViewer2_3
[1EE0:1918][2021-04-26T15:08:39]e314: Failed to cache payload: HelpViewer2_3 from working path: C:\Users\GLENNB~1\AppData\Local\Temp{bf0d55ea-f272-49bc-8699-22fbdcc115a8}\HelpViewer2_3, error: 0x800b010c.
[1EE0:1918][2021-04-26T15:08:39]e349: Application requested retry of payload: HelpViewer2_3, encountered error: 0x800b010c. Retrying...
[1EF8:168C][2021-04-26T15:08:52]e000: Error 0x800b010c: Failed authenticode verification of payload: C:\ProgramData\Package Cache.unverified\HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:52]e000: Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:52]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache.unverified\HelpViewer2_3, error: 0x800b010c. Deleting file.
[1EF8:168C][2021-04-26T15:08:52]e000: Error 0x800b010c: Failed to cache payload: HelpViewer2_3
[1EE0:1918][2021-04-26T15:08:52]e314: Failed to cache payload: HelpViewer2_3 from working path: C:\Users\GLENNB~1\AppData\Local\Temp{bf0d55ea-f272-49bc-8699-22fbdcc115a8}\HelpViewer2_3, error: 0x800b010c.
[1EE0:1EA8][2021-04-26T15:08:52]e000: Error 0x800b010c: Failed while caching, aborting execution.
[1EF8:1F0C][2021-04-26T15:08:52]i330: Removed bundle dependency provider: {bf0d55ea-f272-49bc-8699-22fbdcc115a8}
[1EF8:1F0C][2021-04-26T15:08:52]i352: Removing cached bundle: {bf0d55ea-f272-49bc-8699-22fbdcc115a8}, from path: C:\ProgramData\Package Cache{bf0d55ea-f272-49bc-8699-22fbdcc115a8}\
[1EE0:1EA8][2021-04-26T15:08:52]e000: MainViewModel.OnBundleAction: Bundle action failed: A certificate was explicitly revoked by its issuer (0x800B010C)
[1EE0:1EA8][2021-04-26T15:08:52]i399: Apply complete, result: 0x800b010c, restart: None, ba requested restart: No
[1EE0:04CC][2021-04-26T15:08:59]i000: MainViewModel.OpenUrl: Opening url: C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646.log
[1EE0:04CC][2021-04-26T15:09:11]i000: MainViewModel.Close: Closed during action: Install
[1EE0:04CC][2021-04-26T15:09:12]i000: ManagedBootstrapperApp.Run: Closing the managed bootstrapper application.
[1EE0:1EA8][2021-04-26T15:09:12]i500: Shutting down, exit code: 0x643
[1EE0:1EA8][2021-04-26T15:09:12]i000: BootstrapperEngineDataModel.OnShutDown: OnShutDown invoked
[1EE0:1EA8][2021-04-26T15:09:12]i000: EventLogHelper.TryWriteEntry: Writing event log entry. EntryType=Information EventId=15001 Message=Ending; None
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: AnotherInstallRunning = Setup is blocked due to another install currently running. Please let the other install complete and then restart the computer if necessary.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: AzureDataStudioCurrentlyRunning = Azure Data Studio is currently running. Please close any open instances of Azure Data Studio and run this installer again.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: AzureDataStudioInstalledVersion =
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: AzureDataStudioInstalledVersionInsider =
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: AzureDataStudioInstallExists = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: AzureDataStudioInstallExistsInsider = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: AzureDataStudioVersion = 1.28.0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: CancelText = C_ancel
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: ChangeText = C_hange
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: CloseText = _Close
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: ContinuePastWarningText = Do you wish to continue?
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: DONOTINSTALLAZUREDATASTUDIO = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: HeaderText = Release 18.9.1
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: InstallationType = Client
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: InstallerLcid = 1033
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: InstallText = _Install
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: InvalidLocationText = Invalid location. Please enter a valid location to proceed.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: IsUpgradeScenario = false
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: LicenseTermsADSText = Azure Data Studio
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: LicenseTermsADSUrl = https://go.microsoft.com/fwlink/?linkid=2140322&clcid=0x::ToInt32(1033)
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: LicenseTermsSSMSText = SQL Server Management Studio
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: LicenseTermsSSMSUrl = https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x::ToInt32(1033)
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: LoadingPackagesText = Loading packages. Please wait...
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: LocationText = _Location:
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: MinimizeButtonAccessibleName = Minimize
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: NETFRAMEWORK45 = 528372
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: Netfx4ClientReleaseX64 = 528372
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: Netfx4FullReleaseX64 = 528372
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: OverallProgressText = Overall Progress
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: PackageProgressText = Package Progress
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: PreviewStatementUrl = https://go.microsoft.com/fwlink/?LinkID=824140
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: PrivacyDisclaimerText = 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}.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: PrivacyStatementText = Privacy Statement
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: ProductVersionVar = 15.0.18384.0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: ProgramFilesFolder = C:\Program Files (x86)\
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: RebootPending = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: RepairText = Repair
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: RestartAlreadyPending = A pending restart is blocking setup from completing. Please restart the computer and run setup again.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: RestartText = Restart
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupBlockedDescriptionText = Something has blocked setup from continuing.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupBlockedText = Setup Blocked
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupCanceledDescriptionText = The setup operation has been canceled.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupCanceledText = Setup Canceled
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupCompletedText = Setup Completed
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupFailedDescriptionText = A failure occured during installation.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupFailedText = Setup Failed
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupHelpDescriptionText = /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}.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupHelpText = Setup Help
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupInstalledText = All specified components have been installed successfully.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupLayoutText = Layout operation has completed.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupLogText = Click here for the log file.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupProgressText = Setup Progress
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupRepairedText = All specified components have been repaired successfully.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupRestartDescriptionText = The computer needs to be restarted before setup can continue.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupRestartText = Restart required in order to complete setup.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupUninstalledText = All specified components have been uninstalled successfully.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupWarningDescriptionText = The following issues may impact the installed application.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SetupWarningText = Setup Warnings
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SSMS18PreReleaseDetected = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SSMSCurrentlyRunning = SSMS is currently running. Please close any open instances of SSMS and run this installer again.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SSMSInstalledLanguageKeyExists = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SSMSInstalledLanguageMatch = true
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SSMSInstallExists = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SSMSINSTALLROOT = C:\Program Files (x86)\Microsoft SQL Server Management Studio 18
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: SubHeaderText = Microsoft SQL Server Management Studio with Azure Data Studio
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: TelemetryDocumentationText = documentation
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: TelemetryDocumentationUrl = https://go.microsoft.com/fwlink/?LinkID=869476
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: TermsAndConditionText = 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}.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: UninstallText = Uninstall
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D12x86_KeyExists = 1
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x64_Bld = 29301
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x64_KeyExists = 1
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x64_Major = 14
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x64_Minor = 28
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x86_Bld = 29301
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x86_KeyExists = 1
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x86_Major = 14
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VCRedist_D14x86_Minor = 28
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VersionNT = 10.0.0.0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: VersionNT64 = 10.0.0.0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WelcomeInstallText = Welcome. Click "Install" to begin.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: Win10OrWS2016NotSupported = This version of Windows 10 or Windows Server 2016 is not supported. Please upgrade to version 1607 or greater.
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleAction = 4
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleElevated = 1
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleInstalled = 0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_AzureDataStudio = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_11_AzureDataStudio.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_HelpViewer2_3 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_0_HelpViewer2_3.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_msoledbsql.msi = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_1_msoledbsql.msi.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_sql_as_oledb_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_2_sql_as_oledb_x64.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_sql_as_oledb_x86 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_3_sql_as_oledb_x86.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_sql_ssms_loc_x64_Loc = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_7_sql_ssms_loc_x64_Loc.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_sql_ssms_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_6_sql_ssms_x64.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_ssms_as_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_9_ssms_as_x64.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_ssms_is = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_10_ssms_is.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_ssms_rs_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_8_ssms_rs_x64.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_SsmsPostInstall_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_12_SsmsPostInstall_x64.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_VS2017IsoShellForSSMS = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_4_VS2017IsoShellForSSMS.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleLog_VSTA2017 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_5_VSTA2017.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleManufacturer = Microsoft Corporation
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleName = Microsoft SQL Server Management Studio - 18.9.1
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleOriginalSource = D:\downloads\~microsoft\SQL Server\SQL Server Management Studio\SSMS-Setup-ENU-18_9_1.exe
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleProviderKey = {bf0d55ea-f272-49bc-8699-22fbdcc115a8}
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_HelpViewer2_3 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_0_HelpViewer2_3_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_sql_as_oledb_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_2_sql_as_oledb_x64_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_sql_as_oledb_x86 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_3_sql_as_oledb_x86_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_sql_ssms_loc_x64_Loc = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_7_sql_ssms_loc_x64_Loc_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_sql_ssms_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_6_sql_ssms_x64_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_ssms_as_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_9_ssms_as_x64_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_ssms_is = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_10_ssms_is_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_ssms_rs_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_8_ssms_rs_x64_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_SsmsPostInstall_x64 = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_12_SsmsPostInstall_x64_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleRollbackLog_VS2017IsoShellForSSMS = C:\Users\GLENNB~1\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20210426150646_4_VS2017IsoShellForSSMS_rollback.log
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleTag =
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: WixBundleVersion = 15.0.18384.0
[1EE0:1EA8][2021-04-26T15:09:12]i410: Variable: YesText = Yes
[1EE0:1EA8][2021-04-26T15:09:12]i007: Exit code: 0x643, restarting: No

The pertinent error appears to be:
[1EF8:168C][2021-04-26T15:08:28]e000: Error 0x800b010c: Failed authenticode verification of payload: C:\ProgramData\Package Cache.unverified\HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:28]e000: Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3
[1EF8:168C][2021-04-26T15:08:28]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache.unverified\HelpViewer2_3, error: 0x800b010c. Deleting file.

I apologise for the tag - I may be posting to the wrong forum...

Could someone give me an idea of what is blocking this installation?
Thanks!

sql-server-general
· 2
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.

Hi @GlennBurkins-0100,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

The response to this post provided no value.

I began the first attempted installation with an up-to-date certificate store. After the Installation failure I completely emptied the local certificate store in order to force the installer to use online resources for all authentications. It did so since after the next installation failure I found 4 certificates in the trusted root store. These could only have come from the SSMS installation attempt.

As for the link to the 17.9.1 installation package why would I want to go backwards, especially since that version doesn’t even full support SQL 2019?

It seems I have proved that both the 18.9 and 18.9.1 installation packages are useless. This is surprising in todays’ software signing world and MS produces a great deal of software! Wake up SSMS team...

1 Vote 1 ·
GlennBurkins-0100 avatar image
1 Vote"
GlennBurkins-0100 answered MarcoZimmermann-2191 published

Preface: I discovered that the installation package for 18.9.1 downloaded from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 in April of this year was a different package when downloaded in July of this year. The April download is the one I utilized for this solution. The SHA256 signature for this file is ce12a64f066df907fb62077e5d22a8c5312893664212cca4660d8ebeee2f59c6.

I attempted to install SSMS with the July package and it failed with a completely new set of failure points.

After much investigating and tweaking I was able to capture the root file causing the error in my initial post. It is part of the HelpViewer 2.3 package. I have posted this file online and shared it at the following link: https://app.box.com/s/hrulas4tlhjmpfjd8q8fo5lv7yijkea1.

My solution is as follows.
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).

There can be no doubt that this issue is due to badly signed packages within the SSMS installers, especially components related to the HelpViewer 2.3 bits. Perhaps this post will catch some program managers eye and decisions will be made to solve the problems within all the packages of this product.

· 2
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.

I have the same problem now: “Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3”.
A day passed, I still can't find the answer.

1 Vote 1 ·

See this post and the answer from Padure Sergiu - That was exactly the case in my environment!
After deleting the Microsoft CAs and importing them from an old, not updated System all went fine!

https://social.msdn.microsoft.com/Forums/security/en-US/9fad8d58-09fc-4143-95ee-0538a9373818/ssms-install-error-code-a-certificate-was-explicitly-revoked-by-its-issuer-0x800b010c?forum=sqltools&prof=required

Hi,

We were able to identify and fix the issue in our company:

During the importing of the roots.sst certificates (created through certutil.exe -generateSSTFromWU roots.sst) the following certificates ended up being corrupted:

Solution was:

  • Deleting these certificates from the certificate store of the affected machines
    - Extracting clean copies of these certificates from the original image
    - Import them through Import-Certificate
    After reboot the error would not appear anymore and we were able to install the newer visual studio applications and also the HP drivers that we were unable to install before.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @GlennBurkins-0100,

Please try to install the Windows root certificates. Refer to the similar thread SSMS Install Error Code: A certificate was explicitly revoked by its issuer (0x800B010C) to get detail steps.

If it is still not work, please try to use SSM 17.9.1, you can get it from here.


If the response is helpful, please click "Accept Answer" and upvote it, thank you.
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.

GlennBurkins-0100 avatar image
0 Votes"
GlennBurkins-0100 answered

Ran signtool verify /all /d /v SSMS-Setup-ENU-18_9_1.exe and got the following:

Verifying: SSMS-Setup-ENU-18_9_1.exe

Signature Index: 0 (Primary Signature)
Hash of file (sha256): BD3C918D92EF9C450DBDA381834F2D48D243F69DAFE8FA48DFD529978C9658C9

Signing Certificate Chain:
Issued to: Microsoft Root Certificate Authority 2011
Issued by: Microsoft Root Certificate Authority 2011
Expires: Sat Mar 22 15:13:04 2036
SHA1 hash: 8F43288AD272F3103B6FB1428485EA3014C0BCFE

     Issued to: Microsoft Code Signing PCA 2011
     Issued by: Microsoft Root Certificate Authority 2011
     Expires:   Wed Jul 08 14:09:09 2026
     SHA1 hash: F252E794FE438E35ACE6E53762C0A234A2C52135

         Issued to: Microsoft Corporation
         Issued by: Microsoft Code Signing PCA 2011
         Expires:   Thu Dec 02 14:31:45 2021
         SHA1 hash: ABDCA79AF9DD48A0EA702AD45260B3C03093FB4B

The signature is timestamped: Fri Apr 16 20:15:10 2021
Timestamp Verified by:
Issued to: Microsoft Root Certificate Authority 2010
Issued by: Microsoft Root Certificate Authority 2010
Expires: Sat Jun 23 15:04:01 2035
SHA1 hash: 3B1EFD3A66EA28B16697394703A72CA340A05BD5

     Issued to: Microsoft Time-Stamp PCA 2010
     Issued by: Microsoft Root Certificate Authority 2010
     Expires:   Tue Jul 01 14:46:55 2025
     SHA1 hash: 2AA752FE64C49ABE82913C463529CF10FF2F04EE

         Issued to: Microsoft Time-Stamp Service
         Issued by: Microsoft Time-Stamp PCA 2010
         Expires:   Mon Apr 11 12:02:19 2022
         SHA1 hash: 56498F57FF216554BD1736EDA17DB1DD9DB1632A

SignTool Error: A certificate chain processed, but terminated in a root
certificate which is not trusted by the trust provider.

Number of signatures successfully Verified: 0
Number of warnings: 0
Number of errors: 1
<end>

All of the certificates listed in the output are found in the trusted certificates store.

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.

ozgurcelik-1370 avatar image
0 Votes"
ozgurcelik-1370 answered ozgurcelik-1370 commented

168541-hata1.jpg



hata1.jpg (10.7 KiB)
· 1
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.

Şaka gibi bir durum bir kullanıcı veya server çalışanımı tam emin değilim fakat biri kendi sistemimde beni bir yerlerden engelleyip duruyor. bu kod farklı yerlerdede karşıma çıkıyor. çözümünü soruyorsun adamlara cvp vermiyorlar. nasıl bir saçmalıktır bu. açık var server'larda o yüzden cevap veremiyorlar sanırım. çünkü hata kodu windows'ta yok sanırım. bir çok yerde kafasına göre veriyor kodu. belkide birileri serverlarda gezinip kafasına göre bir kodda yazıp şaka yapıyor sanırım bize :)) ama gerçektende durum bu. bir kaç tane daha farklı foto atabilirim. ekranımıda izledi bugün. ufacık bir ağ deliği bulsa ağıma giriyor kapatıcam diye bi hal oldum delikleri. en sonunda ağ bağlantımızda gitti. Allahtan wifi etkin ya.

0 Votes 0 ·