Share via

Unable to install Microsoft SQL Server Data Tools

Jason Heaney 1 Reputation point
2020-10-27T19:47:16.84+00:00

Hello,

I've searched the internet and tried several fixes for this but I am not able to install SSDT release 15.9.6. I am installing it on MS Windows Server 2016 Datacenter, AWS instance.

It keeps erroring out:

Setup Failed

Incorrect Function (0x80070001)

Here's the log file

[246C:2A14][2020-10-27T12:21:09]i001: Burn v3.11.0.1528, Windows v10.0 (Build 14393: Service Pack 0), path: C:\Users\HDADMI~1\AppData\Local\Temp\1{04C358AD-E499-4362-8E64-DF847713DB79}.cr\SSDT-Setup-ENU.exe
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'ProductVersionVar' to value '14.0.16222.0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'HeaderText' to value 'Release 15.9.6'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SubHeaderText' to value 'Microsoft SQL Server Data Tools'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'VSSqlEvergreenLink' to value 'https://go.microsoft.com/fwlink/?linkid=2020401'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'LicenseTermsUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=853826&clcid=0x409'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'PreviewStatementUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=824140&clcid=0x409'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'TelemetryDocumentationUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=853829&clcid=0x409'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SystemLocaleMismatch' to value 'Setup detected mismatch between the languages of the installer and the OS. Use the English-language version installer, or install the language pack and change the format and system locales through the regional settings in the control panel.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'LcidMismatchWarning' to value 'Operating system language mismatch detected.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'LicenseTermsText' to value 'License Terms'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'PrivacyStatementText' to value 'Privacy Statement'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'TelemetryDocumentationText' to value 'documentation'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'TermsAndConditionText' to value 'By clicking the "Next" button, I acknowledge that I accept the {License Terms} and {Privacy Statement}.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'PrivacyDisclaimerText' to value 'SQL Server Data Tools 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}.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'InstallerLcid' to value '1033'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'CancelText' to value 'Cancel'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'CancelPromptText' to value 'Are you sure you want to cancel?'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'PromptToUninstallOldExtensionText' to value 'Seems you have installed a previous version of SSAS or SSRS extension that is incompatible with the version to be installed, you may need to uninstall both of them before continuing the setup, or current installation may fail. Do you want to continue anyway?'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'UninstallPromptText' to value 'Some SQL Server Data Tools components will not be uninstalled because removing them would place this computer in an unsupproted state. Please manually remove them in Control Panel.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'CloseText' to value 'Close'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'ContinuePastWarningText' to value 'Do you wish to continue?'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'InstallText' to value 'Install'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'NextText' to value 'Next'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'ModifyText' to value 'Modify'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'InstallationProgressText' to value 'Installation Progress'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'DownloadProgressText' to value 'Download Progress'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'RepairText' to value 'Repair'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'RestartText' to value 'Restart'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupBlockedDescriptionText' to value 'Something has blocked setup from continuing.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupBlockedText' to value 'Setup Blocked'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupCanceledDescriptionText' to value 'The setup operation has been canceled.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupCanceledText' to value 'Setup Canceled'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupCompletedText' to value 'Setup Completed'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupFailedDescriptionText' to value 'A failure occured during installation.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupFailedText' to value 'Setup Failed'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupHelpDescriptionText' to value '
/install | /repair | /uninstall | /layout - installs, repairs, uninstalls or creates a complete local copy of the bundle in directory. 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 log.txt - logs to a specific file. By default a log file is created in %TEMP%\SsdtSetup

/help | /h | /? - displays this help.

Additonal arguments for /install:

INSTALLAS[:<VSInstanceIds>] - installs SSAS to specified VS 2017 instances.

INSTALLRS[:<VSInstanceIds>] - installs SSRS to specified VS 2017 instances.

INSTALLIS[:<VSInstanceIds>] - installs SSIS to specified VS 2017 instances.

INSTALLALL[:<VSInstanceIds>] - installs all above to specified VS 2017 instances.

INSTALLVSSQL[:<Nickname>] - installs new SQL Server Data Tools for Visual Studio 2017 instance.

VSInstanceIds is the list of target VS 2017 instance ids separated by comma. It can be absent in two cases : 1) There is only one VS 2017 instance installed on current machine; 2) INSTALLVSSQL is present (VSInstanceIds will be omitted in this case).

Nickname is the nickname of new SQL Server Data Tools for Visual Studio 2017 instance. If it is absent, the nickname will be "SSDT" by default.
'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupHelpText' to value 'Setup Help'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupInstalledText' to value 'All specified components have been installed successfully.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupLayoutText' to value 'Layout operation has completed.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupLogText' to value 'Click here for the log file.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupProgressText' to value 'Setup Progress'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupRepairedText' to value 'All specified components have been repaired successfully.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupRestartDescriptionText' to value 'The computer needs to be restarted before setup can continue.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupRestartText' to value 'Restart required in order to complete setup.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupUninstalledText' to value 'All specified components have been uninstalled successfully.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupWarningDescriptionText' to value 'The following issues may impact the installed application.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetupWarningText' to value 'Setup Warnings'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'UninstallText' to value 'Uninstall'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'WelcomeInstallText' to value 'Welcome. Click "Next" to begin.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'YesText' to value 'Yes'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'RestartAlreadyPending' to value 'A pending restart is blocking setup from completing. Please restart the computer and run setup again.'
[246C:2A14][2020-10-27T12:21:09]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.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'NewSqlShellDisplayName' to value 'Install new SQL Server Data Tools for Visual Studio 2017 instance'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SetNicknameText' to value 'Set a nickname for the new Visual Studio 2017 instance:'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'NicknameNotUnique' to value 'The nickname "{0}" is not unique.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'InvalidNickname' to value 'The nickname cannot contain characters that cannot appear in a file name.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'NicknameArgument' to value ''
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'NewSqlShellNickname' to value 'SSDT'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SqlShellDisplayName' to value 'Microsoft SQL Server Data Tools for Visual Studio 2017'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLVSSQLSHELL' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLAS' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLRS' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLIS' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLISSingletons' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLEDVSSQLSHELL' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLEDAS' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLEDRS' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing numeric variable 'INSTALLEDIS' to value '0'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'ASVSINSTANCES' to value ''
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'RSVSINSTANCES' to value ''
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'ISVSINSTANCES' to value ''
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SelectVSInstanceText' to value 'Install tools to this Visual Studio 2017 instance:'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SelectSqlToolsText' to value 'Install tools for these SQL Server features:'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SelectVSInstanceToModifyText' to value 'Modify this Visual Studio 2017 instance:'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'VSInstanceNotSelectedText' to value 'Please select a Visual Studio 2017 instance.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'VSInstanceNeedUpdateText' to value 'The current installation requires Visual Studio 2017 version number {0} or higher. Please upgrade your Visual Studio instance before continuing the setup.'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'CloseProcessText' to value 'Please close following processes before continuing the setup:'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'SsdtText' to value 'SQL Server Database'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'AnalysisServicesText' to value 'SQL Server Analysis Services'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'ReportingServicesText' to value 'SQL Server Reporting Services'
[246C:2A14][2020-10-27T12:21:09]i000: Initializing string variable 'IntegrationServicesText' to value 'SQL Server Integration Services'
[246C:2A14][2020-10-27T12:21:09]i009: Command Line: '-burn.clean.room=C:\Users\hdadminjh\Desktop\SSDT-Setup-ENU.exe -burn.filehandle.attached=552 -burn.filehandle.self=560'
[246C:2A14][2020-10-27T12:21:09]i000: Setting string variable 'WixBundleOriginalSource' to value 'C:\Users\hdadminjh\Desktop\SSDT-Setup-ENU.exe'
[246C:2A14][2020-10-27T12:21:09]i000: Setting string variable 'WixBundleOriginalSourceFolder' to value 'C:\Users\hdadminjh\Desktop\'
[246C:2A14][2020-10-27T12:21:10]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\HDADMI~1\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20201027122110.log'
[246C:2A14][2020-10-27T12:21:10]i000: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Data Tools - Visual Studio 2017'
[246C:2A14][2020-10-27T12:21:10]i000: Setting string variable 'WixBundleManufacturer' to value 'Microsoft Corporation'
[246C:2A14][2020-10-27T12:21:10]i000: Loading managed bootstrapper application.
[246C:2A14][2020-10-27T12:21:10]i000: Creating BA thread to run asynchronously.
[246C:1D88][2020-10-27T12:21:10]i000: ManagedBootstrapperApp.Run: Launcing the managed bootstrapper application.
[246C:1D88][2020-10-27T12:21:10]i000: BootstrapperMetadataModel.Initialize: Start loading the bootstrapper app data xml file
[246C:1D88][2020-10-27T12:21:10]i000: BootstrapperMetadataModel.Initialize: Completed loading the bootstrapper app data xml file content: <BootstrapperApplicationData xmlns="http://schemas.microsoft.com/wix/2010/BootstrapperApplicationData">
<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 > v6.2" Message="The current operating system is not supported. This application requires at least Windows 7 SP1 or Windows 8.1 to run." />
<WixBundleProperties DisplayName="Microsoft SQL Server Data Tools - Visual Studio 2017" LogPathVariable="WixBundleLog" Compressed="no" Id="{29c86c9a-0565-49e8-bef2-4e74c7c55fb2}" UpgradeCode="{D84A1AA8-9550-4475-8B58-B0C3B953A47B}" PerMachine="yes" />
<WixMbaPrereqInformation PackageId="NetFx461Web" LicenseUrl="http://referencesource.microsoft.com/license.html" />
<WixPackageProperties Package="NetFx461Web" Vital="yes" DisplayName="Microsoft .NET Framework 4.6.1" Description="Microsoft .NET Framework 4.6.1 Setup" DownloadSize="1424328" PackageSize="1424328" InstalledSize="1424328" PackageType="Exe" Permanent="yes" LogPathVariable="NetFx461FullLog" RollbackLogPathVariable="WixBundleRollbackLog_NetFx461Web" Compressed="no" DisplayInternalUI="no" Version="4.6.1055.0" Cache="yes" />
<WixPackageProperties Package="VS_SQL_UpdateInstaller" Vital="yes" DisplayName="Update Visual Studio Installer" Description="VSSqlBootstrapper" DownloadSize="46944" PackageSize="46944" InstalledSize="46944" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VS_SQL_UpdateInstaller" RollbackLogPathVariable="WixBundleRollbackLog_VS_SQL_UpdateInstaller" Compressed="yes" DisplayInternalUI="no" Version="14.0.16222.0" InstallCondition="INSTALLVSSQLSHELL = 1" Cache="yes" />
<WixPackageProperties Package="VS_SQL" Vital="yes" DisplayName="Microsoft SQL Server Data Tools for Visual Studio 2017" Description="VSSqlBootstrapper" DownloadSize="46944" PackageSize="46944" InstalledSize="46944" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VS_SQL" RollbackLogPathVariable="WixBundleRollbackLog_VS_SQL" Compressed="yes" DisplayInternalUI="no" Version="14.0.16222.0" InstallCondition="INSTALLVSSQLSHELL = 1" Cache="yes" />
<WixPackageProperties Package="Microsoft.DataTools.AnalysisServices" Vital="yes" DisplayName="SQL Server Analysis Services" Description="Microsoft VSIX Bootstrapper" DownloadSize="353360669" PackageSize="353360669" InstalledSize="353360669" PackageType="Exe" Permanent="no" LogPathVariable="WixBundleLog_Microsoft.DataTools.AnalysisServices" RollbackLogPathVariable="WixBundleRollbackLog_Microsoft.DataTools.AnalysisServices" Compressed="yes" DisplayInternalUI="no" Version="1.0.25.25203" InstallCondition="INSTALLAS = 1" Cache="yes" />
<WixPackageProperties Package="Microsoft.DataTools.ReportingServices" Vital="yes" DisplayName="SQL Server Reporting Services" Description="Microsoft VSIX Bootstrapper" DownloadSize="145089003" PackageSize="145089003" InstalledSize="145089003" PackageType="Exe" Permanent="no" LogPathVariable="WixBundleLog_Microsoft.DataTools.ReportingServices" RollbackLogPathVariable="WixBundleRollbackLog_Microsoft.DataTools.ReportingServices" Compressed="yes" DisplayInternalUI="no" Version="1.0.25.25203" InstallCondition="INSTALLRS = 1" Cache="yes" />
<WixPackageProperties Package="VCRedist2010" Vital="yes" DisplayName="Microsoft Visual C++ 2010 x86 Redistributable" Description="Microsoft Visual C++ 2010 x86 Redistributable Setup" DownloadSize="8990552" PackageSize="8990552" InstalledSize="8990552" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VCRedist2010" RollbackLogPathVariable="WixBundleRollbackLog_VCRedist2010" Compressed="yes" DisplayInternalUI="no" Version="10.0.40219.325" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="Net47DevPack" Vital="yes" DisplayName="Microsoft .NET Framework 4.7 Developer Pack" Description="Microsoft .NET Framework 4.7 Developer Pack" DownloadSize="86492264" PackageSize="86492264" InstalledSize="86492264" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_Net47DevPack" RollbackLogPathVariable="WixBundleRollbackLog_Net47DevPack" Compressed="yes" DisplayInternalUI="no" Version="4.7.2053.0" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<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" Version="15.0.27520.0" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SSISOneDesigner2012" Vital="yes" DisplayName="SQL Server Integration Services 2012" DownloadSize="18739200" PackageSize="18739200" InstalledSize="81367045" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SSISOneDesigner2012" RollbackLogPathVariable="WixBundleRollbackLog_SSISOneDesigner2012" Compressed="yes" DisplayInternalUI="no" ProductCode="{DB97C76B-9116-42C5-8814-0041856EB9E6}" UpgradeCode="{2BD50741-A322-4322-88FC-10AB25D1F022}" Version="11.4.7001.0" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SSISOneDesigner2014" Vital="yes" DisplayName="SQL Server Integration Services 2014" DownloadSize="19030016" PackageSize="19030016" InstalledSize="82629910" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SSISOneDesigner2014" RollbackLogPathVariable="WixBundleRollbackLog_SSISOneDesigner2014" Compressed="yes" DisplayInternalUI="no" ProductCode="{D5D68C12-ECF0-49BB-9722-DA964B722E08}" UpgradeCode="{6F7A1DA1-256A-44E7-A545-34FDCE9A950E}" Version="12.2.5556.0" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SSISOneDesigner2016" Vital="yes" DisplayName="SQL Server Integration Services 2016" DownloadSize="48578560" PackageSize="48578560" InstalledSize="132874714" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SSISOneDesigner2016" RollbackLogPathVariable="WixBundleRollbackLog_SSISOneDesigner2016" Compressed="yes" DisplayInternalUI="no" ProductCode="{A16CB865-1DD2-4FFC-910D-DC926ED448E3}" UpgradeCode="{653810A4-0DB5-4724-BB7A-892A9DAF0C7F}" Version="13.1.4495.10" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SQL_AS_AMO2012" Vital="yes" DisplayName="Microsoft SQL Server 2012 Analysis Management Objects " DownloadSize="2834432" PackageSize="2834432" InstalledSize="10705800" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SQL_AS_AMO2012" RollbackLogPathVariable="WixBundleRollbackLog_SQL_AS_AMO2012" Compressed="yes" DisplayInternalUI="no" ProductCode="{53086A62-13F3-4FC5-AA41-211FD74340B3}" UpgradeCode="{DB066FBE-0B6E-4B4A-874D-34B705DDCB11}" Version="11.4.7001.0" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SQL_AS_AMO2014" Vital="yes" DisplayName="Microsoft SQL Server 2014 Analysis Management Objects " DownloadSize="3067904" PackageSize="3067904" InstalledSize="11227520" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SQL_AS_AMO2014" RollbackLogPathVariable="WixBundleRollbackLog_SQL_AS_AMO2014" Compressed="yes" DisplayInternalUI="no" ProductCode="{888AE2B5-7376-40F0-A0DD-A1D0151F41F9}" UpgradeCode="{751DACC1-983F-427D-B4EA-170D95D14749}" Version="12.2.5556.0" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SQL_AS_AMO2016" Vital="yes" DisplayName="Microsoft SQL Server 2016 Analysis Management Objects " DownloadSize="4554752" PackageSize="4554752" InstalledSize="21343469" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SQL_AS_AMO2016" RollbackLogPathVariable="WixBundleRollbackLog_SQL_AS_AMO2016" Compressed="yes" DisplayInternalUI="no" ProductCode="{32C74307-3B94-4992-A275-22F810D62551}" UpgradeCode="{E794D589-5251-453C-818F-7546BCA7210D}" Version="13.1.4495.10" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SQL_AS_OLEDB2016" Vital="yes" DisplayName="Microsoft AS OLE DB Provider for SQL Server 2016" DownloadSize="31809536" PackageSize="31809536" InstalledSize="207152002" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SQL_AS_OLEDB2016" RollbackLogPathVariable="WixBundleRollbackLog_SQL_AS_OLEDB2016" Compressed="yes" DisplayInternalUI="no" ProductCode="{C3F39D86-CF82-4666-82C6-4FF7B4FCDEBD}" UpgradeCode="{904ACAB5-C3C2-478E-B943-A98D54BE6FDF}" Version="13.1.4495.10" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SSDTISSingleton140" Vital="yes" DisplayName="SQL Server Integration Services Singleton" DownloadSize="1994752" PackageSize="1994752" InstalledSize="245648" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SSDTISSingleton140" RollbackLogPathVariable="WixBundleRollbackLog_SSDTISSingleton140" Compressed="yes" DisplayInternalUI="no" ProductCode="{295DDC25-2FE0-4C5C-9C66-6B2B5A30ADB3}" UpgradeCode="{E7BE17EF-43FE-4574-8538-8AF517BFC473}" Version="14.0.3002.136" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="SSDTISSingleton" Vital="yes" DisplayName="SQL Server Integration Services Singleton" DownloadSize="2158592" PackageSize="2158592" InstalledSize="317216" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SSDTISSingleton" RollbackLogPathVariable="WixBundleRollbackLog_SSDTISSingleton" Compressed="yes" DisplayInternalUI="no" ProductCode="{E00E68F7-A69F-42E9-9BC7-887F740D06DA}" UpgradeCode="{8463EFC1-E253-4F8F-8A0F-4FC93242E446}" Version="15.0.2000.128" InstallCondition="INSTALLISSingletons = 1" Cache="yes" />
<WixPackageProperties Package="ISVsixPreInstall" Vital="yes" DisplayName="SQL Server Integration Services Pre Install" Description=" " DownloadSize="33680" PackageSize="33680" InstalledSize="33680" PackageType="Exe" Permanent="no" LogPathVariable="WixBundleLog_ISVsixPreInstall" RollbackLogPathVariable="WixBundleRollbackLog_ISVsixPreInstall" Compressed="yes" DisplayInternalUI="no" Version="15.0.2000.128" InstallCondition="INSTALLIS = 1" Cache="yes" />
<WixPackageProperties Package="Microsoft.DataTools.IntegrationServices" Vital="yes" DisplayName="SQL Server Integration Services" Description="Microsoft VSIX Bootstrapper" DownloadSize="229696744" PackageSize="229696744" InstalledSize="229696744" PackageType="Exe" Permanent="no" LogPathVariable="WixBundleLog_Microsoft.DataTools.IntegrationServices" RollbackLogPathVariable="WixBundleRollbackLog_Microsoft.DataTools.IntegrationServices" Compressed="yes" DisplayInternalUI="no" Version="1.0.25.25203" InstallCondition="INSTALLIS = 1" Cache="yes" />
<WixPackageProperties Package="ISVsixPostInstall" Vital="yes" DisplayName="SQL Server Integration Services Post Install" Description=" " DownloadSize="54160" PackageSize="54160" InstalledSize="54160" PackageType="Exe" Permanent="no" LogPathVariable="WixBundleLog_ISVsixPostInstall" RollbackLogPathVariable="WixBundleRollbackLog_ISVsixPostInstall" Compressed="yes" DisplayInternalUI="no" Version="15.0.2000.128" InstallCondition="INSTALLIS = 1" Cache="yes" />
<WixPayloadProperties Payload="NetFx461Web" Package="NetFx461Web" Name="redist\NDP461-KB3102438-Web.exe" Size="1424328" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=671728" LayoutOnly="no" />
<WixPayloadProperties Payload="VS_SQL_UpdateInstaller" Package="VS_SQL_UpdateInstaller" Container="WixAttachedContainer" Name="VSSqlBootstrapper.exe" Size="23472" LayoutOnly="no" />
<WixPayloadProperties Payload="pay68E613F13CCE31A592486302A5CF7E5C" Package="VS_SQL_UpdateInstaller" Container="WixAttachedContainer" Name="VSSqlBootstrapper.exe" Size="23472" LayoutOnly="no" />
<WixPayloadProperties Payload="VS_SQL" Package="VS_SQL" Container="WixAttachedContainer" Name="VSSqlBootstrapper.exe" Size="23472" LayoutOnly="no" />
<WixPayloadProperties Payload="pay68E613F13CCE31A592486302A5CF7E5C" Package="VS_SQL" Container="WixAttachedContainer" Name="VSSqlBootstrapper.exe" Size="23472" LayoutOnly="no" />
<WixPayloadProperties Payload="Microsoft.DataTools.AnalysisServices" Package="Microsoft.DataTools.AnalysisServices" Container="WixAttachedContainer" Name="VSIXBootstrapper.exe" Size="180424" LayoutOnly="no" />
<WixPayloadProperties Payload="payD7E208FD72C805C12AF90D7338AC652B" Package="Microsoft.DataTools.AnalysisServices" Container="WixAttachedContainer" Name="VSIXBootstrapper.exe" Size="180424" LayoutOnly="no" />
<WixPayloadProperties Payload="payF9A9531F07EB8D8F892A03E014A45FA2" Package="Microsoft.DataTools.AnalysisServices" Container="WixAttachedContainer" Name="payload\Microsoft.DataTools.AnalysisServices.VSIX" Size="352999821" LayoutOnly="no" />
<WixPayloadProperties Payload="Microsoft.DataTools.ReportingServices" Package="Microsoft.DataTools.ReportingServices" Container="WixAttachedContainer" Name="VSIXBootstrapper.exe" Size="180424" LayoutOnly="no" />
<WixPayloadProperties Payload="payD7E208FD72C805C12AF90D7338AC652B" Package="Microsoft.DataTools.ReportingServices" Container="WixAttachedContainer" Name="VSIXBootstrapper.exe" Size="180424" LayoutOnly="no" />
<WixPayloadProperties Payload="pay8C8EE098CF6E4AD112779374EB20CEF6" Package="Microsoft.DataTools.ReportingServices" Container="WixAttachedContainer" Name="payload\Microsoft.DataTools.ReportingServices.VSIX" Size="144728155" LayoutOnly="no" />
<WixPayloadProperties Payload="VCRedist2010" Package="VCRedist2010" Container="WixAttachedContainer" Name="payload\vcredist_x86.exe" Size="8990552" LayoutOnly="no" />
<WixPayloadProperties Payload="Net47DevPack" Package="Net47DevPack" Container="WixAttachedContainer" Name="payload\NDP47-DevPack-KB3186612-ENU.exe" Size="86492264" LayoutOnly="no" />
<WixPayloadProperties Payload="VSTA2017" Package="VSTA2017" Container="WixAttachedContainer" Name="payload\vsta_setup.exe" Size="13395792" LayoutOnly="no" />
<WixPayloadProperties Payload="SSISOneDesigner2012" Package="SSISOneDesigner2012" Container="WixAttachedContainer" Name="payload\SSISOneDesigner2012.msi" Size="18739200" LayoutOnly="no" />
<WixPayloadProperties Payload="SSISOneDesigner2014" Package="SSISOneDesigner2014" Container="WixAttachedContainer" Name="payload\SSISOneDesigner2014.msi" Size="19030016" LayoutOnly="no" />
<WixPayloadProperties Payload="SSISOneDesigner2016" Package="SSISOneDesigner2016" Container="WixAttachedContainer" Name="payload\SSISOneDesigner2016.msi" Size="48578560" LayoutOnly="no" />
<WixPayloadProperties Payload="SQL_AS_AMO2012" Package="SQL_AS_AMO2012" Container="WixAttachedContainer" Name="payload\SQL_AS_AMO2012.msi" Size="2834432" LayoutOnly="no" />
<WixPayloadProperties Payload="SQL_AS_AMO2014" Package="SQL_AS_AMO2014" Container="WixAttachedContainer" Name="payload\SQL_AS_AMO2014.msi" Size="3067904" LayoutOnly="no" />
<WixPayloadProperties Payload="SQL_AS_AMO2016" Package="SQL_AS_AMO2016" Container="WixAttachedContainer" Name="payload\SQL_AS_AMO2016.msi" Size="4554752" LayoutOnly="no" />
<WixPayloadProperties Payload="SQL_AS_OLEDB2016" Package="SQL_AS_OLEDB2016" Container="WixAttachedContainer" Name="payload\SQL_AS_OLEDB2016.msi" Size="31809536" LayoutOnly="no" />
<WixPayloadProperties Payload="SSDTISSingleton140" Package="SSDTISSingleton140" Container="WixAttachedContainer" Name="payload\SSDTISSingleton140.msi" Size="1994752" LayoutOnly="no" />
<WixPayloadProperties Payload="SSDTISSingleton" Package="SSDTISSingleton" Container="WixAttachedContainer" Name="payload\SSDTISSingleton.msi" Size="2158592" LayoutOnly="no" />
<WixPayloadProperties Payload="ISVsixPreInstall" Package="ISVsixPreInstall" Container="WixAttachedContainer" Name="ISVsixPreInstall.exe" Size="33680" LayoutOnly="no" />
<WixPayloadProperties Payload="Microsoft.DataTools.IntegrationServices" Package="Microsoft.DataTools.IntegrationServices" Container="WixAttachedContainer" Name="VSIXBootstrapper.exe" Size="180424" LayoutOnly="no" />
<WixPayloadProperties Payload="payD7E208FD72C805C12AF90D7338AC652B" Package="Microsoft.DataTools.IntegrationServices" Container="WixAttachedContainer" Name="VSIXBootstrapper.exe" Size="180424" LayoutOnly="no" />
<WixPayloadProperties Payload="pay11BD044C641C550D053D8A51650473CF" Package="Microsoft.DataTools.IntegrationServices" Container="WixAttachedContainer" Name="payload\Microsoft.DataTools.IntegrationServices.VSIX" Size="229335896" LayoutOnly="no" />
<WixPayloadProperties Payload="ISVsixPostInstall" Package="ISVsixPostInstall" Container="WixAttachedContainer" Name="ISVsixPostInstall.exe" Size="54160" LayoutOnly="no" />
</BootstrapperApplicationData>
[246C:1D88][2020-10-27T12:21:10]e000: MainViewModel: RCBitsDetected not found.
[246C:1D88][2020-10-27T12:21:10]i000: Setting string variable 'NicknameArgument' to value '--nickname 'SSDT''
[246C:1D88][2020-10-27T12:21:10]e000: MainViewModel.GetVsInstances: Failed to get VS Instances: Retrieving the COM class factory for component with CLSID {177F0C4A-1CD3-4DE7-A32C-71DB

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,799 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,201 Reputation points Microsoft Vendor
    2020-10-28T05:42:52.14+00:00

    Hi @Jason Heaney ,

    Please try the solution from this bogs SSDT for Visual Studio 2017 – Fixing the Install Error.

    Please also check if below similar thread could help you.

    SSDT installation issue (Failed to execute EXE package.)
    SSDT 2017 installation error 0x80070001

    Hope this could help you.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.

  2. gabster 1 Reputation point
    2020-11-02T11:43:23.883+00:00

    Hi,

    i have the same error when trying o install ssdt 2017 on windows server 2019 (fresh installation).
    I will try now one of the solutions in the links you gave and get back to you.

    Thanks

    0 comments
  3. gabster 1 Reputation point
    2020-11-02T12:05:27.207+00:00

    Hi,

    tried the first link, and it appears that i don't have the payload folder created so cannot progress further with this.
    I do have full internet on my server, and i have all the prerequisites in place before trying to install ssdt 2017 (sql server 2017).
    I will try the offline installation now

    36819-image.png

    Best regards,
    Gabriela

    0 comments
  4. Murali V 1 Reputation point
    2021-10-22T21:06:05.567+00:00

    hi,

    this is not issue ..! there is one one drop box in second u have to select VS2017, before install VS2017

    0 comments
  5. Lin_Rao 6 Reputation points
    2021-11-18T18:14:34.667+00:00

    Solution: do check if the TLS 1.0 is blocked in the PC, if so it will not allow you to install / proceed further. Export and delete the registry folder "Client" and re-run Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client

    Setup Failed
    Incorrect Function (0x80070001)

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.