March 27, 2018 at 9:24 am
Hi guys,
I've exhausted my ideas on this one, and no amount of Googling seems to add the matter. I'm having problems installing SSDT 2015/2017 on Windows 10 at the office. Every attempt just ends in failure, however, having the software is a a significant requirement, which means, at the moment, the DBA team can't update their PCs.
The problem is occurring on both PCs i've got at the moment, so this very much points to the problem being Windows 10. I've included the logs below:[2D10:122C][2018-03-27T15:05:55]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
[2D10:122C][2018-03-27T15:05:55]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
...This repeats every 2 seconds until..
[2D10:122C][2018-03-27T15:17:05]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
[2D10:122C][2018-03-27T15:17:05]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
[31E0:2870][2018-03-27T15:17:06]e000: Error 0x80070001: Process returned error: 0x1[31E0:2870][2018-03-27T15:17:06]e000: Error 0x80070001: Failed to execute EXE package.
[2D10:122C][2018-03-27T15:17:06]e000: Error 0x80070001: Failed to configure per-machine EXE package.
[2D10:122C][2018-03-27T15:17:06]i000: MainViewModel.OnPackageAction: Install Completed for package Update Visual Studio Installer (id: VS_SQL_UpdateInstaller)
[2D10:122C][2018-03-27T15:17:06]i319: Applied execute package: VS_SQL_UpdateInstaller, result: 0x80070001, restart: None
[2D10:122C][2018-03-27T15:17:06]e000: Error 0x80070001: Failed to execute EXE package.
[31E0:2870][2018-03-27T15:17:06]i351: Removing cached package: VS_SQL_UpdateInstaller, from path: C:\ProgramData\Package Cache\ABC974F92D030AEA79AEF11D079AA4BBD5EE6FE2\
On SSDT 2017 I've tried copying the file SSDT-Setup.ENU.exe to it's own directory in C: and running it, to no avail. I also then used powershell and ran C:\SSDT\SSDT-Setup.ENU.exe /layout then ran the file redist\NDP461-KB3102438-Web.exe (which did not install anything as the requisites were met), and then the file payload\vsta_setup.exe. Then tried the installer again. Same error.
Visual Studio 2015 Professional is installed and running, so that's not an issue either. I've also tried running the install as adminstrator, and also logged in as the local administrator and run it. Same problems.
Really don't know what else to do at this stage... Anyone else faced this issue and/or resolved it?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 28, 2018 at 4:07 pm
Thom A - Tuesday, March 27, 2018 9:24 AMHi guys,I've exhausted my ideas on this one, and no amount of Googling seems to add the matter. I'm having problems installing SSDT 2015/2017 on Windows 10 at the office. Every attempt just ends in failure, however, having the software is a a significant requirement, which means, at the moment, the DBA team can't update their PCs.
The problem is occurring on both PCs i've got at the moment, so this very much points to the problem being Windows 10. I've included the logs below:
[2D10:122C][2018-03-27T15:05:55]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
[2D10:122C][2018-03-27T15:05:55]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
...This repeats every 2 seconds until..
[2D10:122C][2018-03-27T15:17:05]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
[2D10:122C][2018-03-27T15:17:05]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 3
[31E0:2870][2018-03-27T15:17:06]e000: Error 0x80070001: Process returned error: 0x1[31E0:2870][2018-03-27T15:17:06]e000: Error 0x80070001: Failed to execute EXE package.
[2D10:122C][2018-03-27T15:17:06]e000: Error 0x80070001: Failed to configure per-machine EXE package.
[2D10:122C][2018-03-27T15:17:06]i000: MainViewModel.OnPackageAction: Install Completed for package Update Visual Studio Installer (id: VS_SQL_UpdateInstaller)
[2D10:122C][2018-03-27T15:17:06]i319: Applied execute package: VS_SQL_UpdateInstaller, result: 0x80070001, restart: None
[2D10:122C][2018-03-27T15:17:06]e000: Error 0x80070001: Failed to execute EXE package.
[31E0:2870][2018-03-27T15:17:06]i351: Removing cached package: VS_SQL_UpdateInstaller, from path: C:\ProgramData\Package Cache\ABC974F92D030AEA79AEF11D079AA4BBD5EE6FE2\On SSDT 2017 I've tried copying the file
SSDT-Setup.ENU.exeto it's own directory in C: and running it, to no avail. I also then used powershell and ranC:\SSDT\SSDT-Setup.ENU.exe /layoutthen ran the fileredist\NDP461-KB3102438-Web.exe(which did not install anything as the requisites were met), and then the filepayload\vsta_setup.exe. Then tried the installer again. Same error.Visual Studio 2015 Professional is installed and running, so that's not an issue either. I've also tried running the install as adminstrator, and also logged in as the local administrator and run it. Same problems.
Really don't know what else to do at this stage... Anyone else faced this issue and/or resolved it?
Did you ever figure this out? I hit the same error many version before so I was curious about this. I had to uninstall and reinstall VS. It worked but I have no idea why.
I was just searching on it and believe I found your other post maybe - followed by some obnoxious person who said they would do whatever they want with posts. Wow....that person is a total <will only get deleted if I say what I think>. Pretty sure that was you - sorry that happened. Sorrier that I don't have an answer.
Sue
March 29, 2018 at 2:27 am
Sue_H - Wednesday, March 28, 2018 4:07 PMDid you ever figure this out? I hit the same error many version before so I was curious about this. I had to uninstall and reinstall VS. It worked but I have no idea why.
I was just searching on it and believe I found your other post maybe - followed by some obnoxious person who said they would do whatever they want with posts. Wow....that person is a total <will only get deleted if I say what I think>. Pretty sure that was you - sorry that happened. Sorrier that I don't have an answer.Sue
Hi Sue,
Yes, in the end. The PC's are new, so I ended up resetting them both and starting afresh. I installed VS2017 shell first that time, and then added SSDT to that and it seemed much happier. The shell woulnd't even install on the last one. That, however, isn't much of an answer to others; in all honesty. "Reset your PC and try again" isn't going to be great if you're already cemented using that PC.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 29, 2018 at 2:17 pm
Thom A - Thursday, March 29, 2018 2:27 AMSue_H - Wednesday, March 28, 2018 4:07 PMDid you ever figure this out? I hit the same error many version before so I was curious about this. I had to uninstall and reinstall VS. It worked but I have no idea why.
I was just searching on it and believe I found your other post maybe - followed by some obnoxious person who said they would do whatever they want with posts. Wow....that person is a total <will only get deleted if I say what I think>. Pretty sure that was you - sorry that happened. Sorrier that I don't have an answer.Sue
Hi Sue,
Yes, in the end. The PC's are new, so I ended up resetting them both and starting afresh. I installed VS2017 shell first that time, and then added SSDT to that and it seemed much happier. The shell woulnd't even install on the last one. That, however, isn't much of an answer to others; in all honesty. "Reset your PC and try again" isn't going to be great if you're already cemented using that PC.
That's pretty much the same as what I ran into before. I wish I knew what the issue is with this. I haven't seen a good answer on it anywhere. 🙁
Sue
July 19, 2018 at 7:36 am
April 17, 2020 at 9:45 pm
I know this is an old post but thought I'd post what I found today whilst encountering the exact same issue in case it helps someone elseError 0x80070001: Process returned error: 0x1Error 0x80070001: Failed to execute EXE package.
Error 0x80070001: Failed to configure per-machine EXE package.
MainViewModel.OnPackageAction: Install Completed for package Update Visual Studio Installer (id: VS_SQL_UpdateInstaller)
Applied execute package: VS_SQL_UpdateInstaller, result: 0x80070001, restart: None
Error 0x80070001: Failed to execute EXE package.
The installer log file doesnt really give any information of what is wrong however there is another log file for the VS_SQL_UpdateInstaller package which outlined the issue (TLS).The other log file shows the followingVSSqlBootstrapper.exe Information: 0 : Try to download vs_sql.exe from https://aka.ms/vs/15/release/vs_sql.exe. Retry count: 0
VSSqlBootstrapper.exe Error: 0 : Download failed with exception System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.ComponentModel.Win32Exception: The client and server cannot communicate, because they do not possess a common algorithm
The log file is located in C:\Users\xxxxxx\AppData\Local\Temp\SsdtSetup and is in the format "SSDT-Setup-ENU_nnnnnnnnnnnnnnn_nnn_VS_SQL_UpdateInstaller.log"To resolve the issue I did the following1. Manually downloaded and installed vs_sql.exe from https://aka.ms/vs/15/release/vs_sql.exe
2. Launch SSDT-Setup-ENU.exe de-select SSAS, RS and IS (only database services)
3. Uninstall/Change (Control Panel) - "Microsoft SQL Server Data Tools - Visual Studio 2017"
4. Modify
5. Select required components AS/RS/IS
6. Install
Hope that helps
Had to create an account just for this. Thank you so much. Even though it's posted 2 years back, it's still relevant till today. Your solution fixed my troubles.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply