SSDT was installed through the Visual Studio 2017 installer, but didn't include Analysis Services, Reporting Services or Integration Services tooling. I downloaded the latest SQL Server Data Tools installer and tried installing, but only Analysis Services installed. Both SSRS and SSIS fail. Both give:
"Unknown Error 0x80131509).
I've tried several times, rebooted, re-downloaded, nothing worked. If I uninstall SSDT, VS installer will remove many other components, so didn't want to do that without seeing if someone had a solution.
Help?!
Thanks!
End of the log file shows this:
Error 0x80131509: Process returned error: 0x80131509
Error 0x80131509: Failed to execute EXE package.
Error 0x80131509: Failed to configure per-machine EXE package.
MainViewModel.OnPackageAction: Install Completed for package SQL Server Reporting Services (id: Microsoft.DataTools.ReportingServices)
Applied execute package: Microsoft.DataTools.ReportingServices, result: 0x80131509, restart: None
Error 0x80131509: Failed to execute EXE package.
Removed package dependency provider: Microsoft.DataTools.ReportingServices, package: Microsoft.DataTools.ReportingServices
Removing cached package: Microsoft.DataTools.ReportingServices, from path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\
Removed dependency: {f55a890f-6c82-4455-9bb5-2a902cdb7d87} on package provider: Microsoft.DataTools.AnalysisServices, package Microsoft.DataTools.AnalysisServices
MainViewModel.OnPackageAction: Install Started for package SQL Server Analysis Services (id: Microsoft.DataTools.AnalysisServices)
MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 15
Applying rollback package: Microsoft.DataTools.AnalysisServices, action: Uninstall, path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\VSIXBootstrapper.exe, arguments: '"C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\VSIXBootstrapper.exe" /q /admin /instanceIds:"18a2cbc4" /logFile:"C:\Users\sspotts\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20180522091154_000_Microsoft.DataTools.AnalysisServices.log" /u:04a86fc2-dbd5-4222-848e-911638e487fe'
Error 0x80070003: Failed to CreateProcess on path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\VSIXBootstrapper.exe
Error 0x80070003: Failed to execute EXE package.
Error 0x80070003: Failed to configure per-machine EXE package.
MainViewModel.OnPackageAction: Install Completed for package SQL Server Analysis Services (id: Microsoft.DataTools.AnalysisServices)
Applied rollback package: Microsoft.DataTools.AnalysisServices, result: 0x80070003, restart: None
Removed package dependency provider: Microsoft.DataTools.AnalysisServices, package: Microsoft.DataTools.AnalysisServices
Removing cached package: Microsoft.DataTools.AnalysisServices, from path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\
Unable to remove cached package: Microsoft.DataTools.AnalysisServices, from path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\, reason: 0x80070003. Continuing...
MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 100
Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{f55a890f-6c82-4455-9bb5-2a902cdb7d87}, resume: None, restart: None, disable resume: No
Removed bundle dependency provider: {f55a890f-6c82-4455-9bb5-2a902cdb7d87}
Removing cached bundle: {f55a890f-6c82-4455-9bb5-2a902cdb7d87}, from path: C:\ProgramData\Package Cache\{f55a890f-6c82-4455-9bb5-2a902cdb7d87}\
Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{f55a890f-6c82-4455-9bb5-2a902cdb7d87}, resume: None, restart initiated: No, disable resume: No
MainViewModel.OnBundleAction: Bundle action failed: Unknown error (0x80131509) (0x80131509)
Apply complete, result: 0x80131509, restart: None, ba requested restart: No
MainViewModel.OpenUrl: Opening url: C:\Users\sspotts\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20180522091154.log