SSMS While installing Microsoft SQL Server Management Studio with Azure Data Studio setup failed error code(0x800B0111)

Mohammad Amir 26 Reputation points
2022-12-07T15:34:22.287+00:00

While installing the Microsoft SQL Server Management Studio with Azure Data Studio Getting failed as per below error.

Error:-
Setup Failed

Version 18.12.1

The certificate was explicitly marked as untrusted by the user by the user (0x800B0111). Also attached the screenshot for reference.

Installing on Server 2019 (64-bit) 268229-sql.pngwith admin privilege.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,711 questions
{count} vote

7 additional answers

Sort by: Most helpful
  1. Alberto Morillo 32,886 Reputation points MVP
    2022-12-07T21:26:00.65+00:00

    Please download a previous release of SSMS from here and it should work with one of the previous releases.

    You can also try to install the preview version of SSMS v19 from here.

    0 comments No comments

  2. Mohammad Amir 26 Reputation points
    2022-12-08T06:07:55.527+00:00
    [0AFC:2390][2022-12-08T10:00:58]i001: Burn v3.8.1128.0, Windows v6.3 (Build 9600: Service Pack 0), path: C:\Software\New folder\SSMS-Setup-ENU-18.9.1.exe, cmdline: '-burn.unelevated BurnPipe.{5146F322-855F-4F70-B9C9-E1751426EB8B} {85D426CF-B53C-4A21-AD0A-9FA2F360F2D5} 8580'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SSMSINSTALLROOT' to value '[ProgramFilesFolder]Microsoft SQL Server Management Studio 18'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing numeric variable 'SSMSInstallExists' to value '0'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SSMSInstalledLanguageKeyExists' to value 'false'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SSMSInstalledLanguageMatch' to value 'true'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SSMS18PreReleaseDetected' to value 'false'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SSMS18InstalledVersion' to value ''  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'AzureDataStudioInstalledVersion' to value ''  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'AzureDataStudioInstalledVersionInsider' to value ''  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing numeric variable 'AzureDataStudioInstallExists' to value '0'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing numeric variable 'AzureDataStudioInstallExistsInsider' to value '0'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'AzureDataStudioVersion' to value '1.28.0'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing numeric variable 'DONOTINSTALLAZUREDATASTUDIO' to value '0'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'ProductVersionVar' to value '15.0.18384.0'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'HeaderText' to value 'Release 18.9.1'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SubHeaderText' to value 'Microsoft SQL Server Management Studio with Azure Data Studio'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'LicenseTermsSSMSUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x[System.Convert]::ToInt32(1033)'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'LicenseTermsADSUrl' to value 'https://go.microsoft.com/fwlink/?linkid=2140322&clcid=0x[System.Convert]::ToInt32(1033)'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'PreviewStatementUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=824140'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'TelemetryDocumentationUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=869476'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing numeric variable 'InstallerLcid' to value '1033'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'CancelText' to value 'C_ancel'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'CloseText' to value '_Close'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'ContinuePastWarningText' to value 'Do you wish to continue?'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'InstallText' to value '_Install'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'LicenseTermsSSMSText' to value 'SQL Server Management Studio'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'LicenseTermsADSText' to value 'Azure Data Studio'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'LoadingPackagesText' to value 'Loading packages. Please wait...'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'OverallProgressText' to value 'Overall Progress'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'PackageProgressText' to value 'Package Progress'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'PrivacyStatementText' to value 'Privacy Statement'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'TelemetryDocumentationText' to value 'documentation'  
    [0AFC:2390][2022-12-08T10:00:58]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}.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'RepairText' to value 'Repair'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'RestartText' to value 'Restart'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupBlockedDescriptionText' to value 'Something has blocked setup from continuing.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupBlockedText' to value 'Setup Blocked'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupCanceledDescriptionText' to value 'The setup operation has been canceled.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupCanceledText' to value 'Setup Canceled'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupCompletedText' to value 'Setup Completed'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupFailedDescriptionText' to value 'A failure occured during installation.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupFailedText' to value 'Setup Failed'  
    [0AFC:2390][2022-12-08T10:00:58]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}.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupHelpText' to value 'Setup Help'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupInstalledText' to value 'All specified components have been installed successfully.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupLayoutText' to value 'Layout operation has completed.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupLogText' to value 'Click here for the log file.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupProgressText' to value 'Setup Progress'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupRepairedText' to value 'All specified components have been repaired successfully.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupRestartDescriptionText' to value 'The computer needs to be restarted before setup can continue.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupRestartText' to value 'Restart required in order to complete setup.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupUninstalledText' to value 'All specified components have been uninstalled successfully.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupWarningDescriptionText' to value 'The following issues may impact the installed application.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SetupWarningText' to value 'Setup Warnings'  
    [0AFC:2390][2022-12-08T10:00:58]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}.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'UninstallText' to value 'Uninstall'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'WelcomeInstallText' to value 'Welcome. Click "Install" to begin.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'YesText' to value 'Yes'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'RestartAlreadyPending' to value 'A pending restart is blocking setup from completing. Please restart the computer and run setup again.'  
    [0AFC:2390][2022-12-08T10:00:58]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.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'SSMSCurrentlyRunning' to value 'SSMS is currently running. Please close any open instances of SSMS and run this installer again.'  
    [0AFC:2390][2022-12-08T10:00:58]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.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'MinimizeButtonAccessibleName' to value 'Minimize'  
    [0AFC:2390][2022-12-08T10:00:58]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.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'IsUpgradeScenario' to value 'false'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'ChangeText' to value 'C_hange'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'LocationText' to value '_Location:'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Initializing string variable 'InvalidLocationText' to value 'Invalid location. Please enter a valid location to proceed.'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\coeuser\AppData\Local\Temp\SsmsSetup\SSMS-Setup-ENU_20221208100058.log'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Setting string variable 'WixBundleOriginalSource' to value 'C:\Software\New folder\SSMS-Setup-ENU-18.9.1.exe'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Management Studio - 18.9.1'  
    [0AFC:2390][2022-12-08T10:00:58]i000: Loading managed bootstrapper application.  
    [0AFC:2390][2022-12-08T10:00:59]i000: Creating BA thread to run asynchronously.  
    [0AFC:09B8][2022-12-08T10:00:59]i000: ManagedBootstrapperApp.Run: Launching the managed bootstrapper application.  
    [0AFC:09B8][2022-12-08T10:00:59]i000: BootstrapperMetadataModel.Initialize: Start loading the bootstrapper app data xml file  
    [0AFC:09B8][2022-12-08T10:00: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.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>  
    [0AFC:0B68][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Caption: Microsoft Windows Server 2019 Datacenter  
    [0AFC:0B68][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Version: 10.0.17763  
    [0AFC:0B68][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: NetFx4 Version: 4.8.03761  
    [0AFC:0B68][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS UI Culture: English (United States) (1033)  
    [0AFC:0B68][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio InstallLocation: n/a  
    [0AFC:0B68][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio DisplayVersion: n/a  
    [0AFC:0B68][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: Azure Data Studio Version (Major.Minor): n/a  
    [0AFC:09B8][2022-12-08T10:01:00]i000: MainViewModel.CheckFailedConditions: Check whether OS is Windows 10 / Windows Server 2016 pre-RS1 (build <= 10586). OSVersion = 10.0.17763  
    [0AFC:09B8][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.SetCommandLineProperties: Begin  
    [0AFC:09B8][2022-12-08T10:01:00]i000: ManagedBootstrapperApp.SetCommandLineProperties: End  
    [0AFC:2390][2022-12-08T10:01:00]i100: Detect begin, 20 packages  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting string variable 'NETFRAMEWORK45' to value '528049'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{6591F69E-6588-4980-81ED-C8FCBD7EC4B8}_is1'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'AzureDataStudioInstallExists' to value 0  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{6748A5FD-29EB-4BA6-B3C6-E7B981B8D6B0}_is1'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'AzureDataStudioInstallExistsInsider' to value 0  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'AzureDataStudioInstallExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'AzureDataStudioInstallExistsInsider' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\SQL Server Management Studio\18'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'SSMS18PreReleaseDetected' to value 0  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'SSMSInstallExists' to value 0  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstallExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstallExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18\Language'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'SSMSInstalledLanguageKeyExists' to value 0  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]i052: Condition 'SSMSInstalledLanguageKeyExists' evaluates to false.  
    [0AFC:2390][2022-12-08T10:01:00]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.  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\VisualStudio\12.0\VC\Runtimes\x86'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'VCRedist_D12x86_KeyExists' to value 0  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting string variable 'VCRedist_D14x64_Bld' to value '30139'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'VCRedist_D14x64_KeyExists' to value 1  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting string variable 'VCRedist_D14x64_Major' to value '14'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting string variable 'VCRedist_D14x64_Minor' to value '29'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting string variable 'VCRedist_D14x86_Bld' to value '30139'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting numeric variable 'VCRedist_D14x86_KeyExists' to value 1  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting string variable 'VCRedist_D14x86_Major' to value '14'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Setting string variable 'VCRedist_D14x86_Minor' to value '29'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'HKLM\Software\Microsoft\DevDiv\vsta\Servicing\15.0\hosting'  
    [0AFC:2390][2022-12-08T10:01:00]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Package_for_KB2919355~31bf3856ad364e35~amd64~~6.3.1.14'  
    [0AFC:2390][2022-12-
    
    0 comments No comments

  3. Mohammad Amir 26 Reputation points
    2022-12-08T06:10:27.83+00:00

    As suggested by @Alberto Morillo tried to install with v19, 18.9.1 and 18.9.2 also but it getting same error as per screenshot, also paste the logs.

    0 comments No comments

  4. Mohammad Amir 26 Reputation points
    2022-12-08T06:11:18.89+00:00

    268511-ssms-setup-enu-20221208100058-log.txt

    Attached here the error log.

    0 comments No comments