SQL Server Data Tools 2015 installation error

J. McCarthy picture J. McCarthy · Oct 12, 2016 · Viewed 16.7k times · Source

I'm trying to install SQL Server Data Tools - Visual Studio 2015, but I keep getting an "Unspecified error".

The log file is at https://drive.google.com/open?id=0B3CEKzS2Sw8OODNJOXZJVGRWQlU.

I already have Visual Studio Professional 2015 installed.

I want to install SSDT 2015 because my databases were recently migrated from SQL Server 2008 R2 to 2014, and I need to use SSIS. Previously, I used SQL Server Business Intelligence Development Studio to create my DTS packages, which I still have installed to access old packages.

I've tried to find a resolution to my problem but everything seems to be about VS 2013 installation issues.

Please let me know if I need to provide more information.

Here's the relevant section from the linked log file.

[2308:24BC][2016-10-12T09:32:14]: Plan complete, result: 0x0
[2308:24BC][2016-10-12T09:32:14]: Apply begin
[287C:2C64][2016-10-12T09:32:14]: Creating a system restore point.
[287C:2C64][2016-10-12T09:32:21]: Created a system restore point.
[287C:2C64][2016-10-12T09:32:21]: Caching bundle from: 'C:\Users\JENMCC~1\AppData\Local\Temp\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\.be\SSDTSetup.exe' to: 'C:\ProgramData\Package Cache\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\SSDTSetup.exe'
[287C:2C64][2016-10-12T09:32:21]: Registering bundle dependency provider: {2e9e05c8-ae49-4af6-9121-fa821d1b5334}, version: 14.0.60923.0
[2308:28AC][2016-10-12T09:32:21]: Prompt for source of package: DotNet46, payload: DotNet46, path: U:\Downloads\Microsoft\SSDT\SSDT 2015\payload\neutral\NDP461-KB3102436-x86-x64-AllOS.exe
[2308:28AC][2016-10-12T09:32:21]: Acquiring package: DotNet46, payload: DotNet46, download from: https://go.microsoft.com/fwlink/?LinkId=715689
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to send request to URL: https://go.microsoft.com/fwlink/?LinkId=715689
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to send request to URL: https://go.microsoft.com/fwlink/?LinkId=715689
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to connect to URL: https://go.microsoft.com/fwlink/?LinkId=715689
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to get size and time for URL: https://go.microsoft.com/fwlink/?LinkId=715689
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed attempt to download URL: 'https://go.microsoft.com/fwlink/?LinkId=715689' to: 'C:\Users\JENMCC~1\AppData\Local\Temp\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\DotNet46'
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to acquire payload from: 'https://go.microsoft.com/fwlink/?LinkId=715689' to working path: 'C:\Users\JENMCC~1\AppData\Local\Temp\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\DotNet46'
[2308:28AC][2016-10-12T09:32:21]: Failed to acquire payload: DotNet46 to working path: C:\Users\JENMCC~1\AppData\Local\Temp\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\DotNet46, error: 0x80072ee7.
[2308:28AC][2016-10-12T09:32:21]: Applied non-vital package: DotNet46, encountered error: 0x80072ee7. Continuing...
[2308:28AC][2016-10-12T09:32:21]: Prompt for source of package: adalsql13X64, payload: adalsql13X64, path: U:\Downloads\Microsoft\SSDT\SSDT 2015\payload\x64\adalsql.msi
[2308:28AC][2016-10-12T09:32:21]: Acquiring package: adalsql13X64, payload: adalsql13X64, download from: https://go.microsoft.com/fwlink/?LinkId=817285&clcid=0x409
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to send request to URL: https://go.microsoft.com/fwlink/?LinkId=817285&clcid=0x409
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to send request to URL: https://go.microsoft.com/fwlink/?LinkId=817285&clcid=0x409
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to connect to URL: https://go.microsoft.com/fwlink/?LinkId=817285&clcid=0x409
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to get size and time for URL: https://go.microsoft.com/fwlink/?LinkId=817285&clcid=0x409
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed attempt to download URL: 'https://go.microsoft.com/fwlink/?LinkId=817285&clcid=0x409' to: 'C:\Users\JENMCC~1\AppData\Local\Temp\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\adalsql13X64'
[2308:28AC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed to acquire payload from: 'https://go.microsoft.com/fwlink/?LinkId=817285&clcid=0x409' to working path: 'C:\Users\JENMCC~1\AppData\Local\Temp\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\adalsql13X64'
[2308:28AC][2016-10-12T09:32:21]: Failed to acquire payload: adalsql13X64 to working path: C:\Users\JENMCC~1\AppData\Local\Temp\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\adalsql13X64, error: 0x80072ee7.
[287C:2500][2016-10-12T09:32:21]: Removing cached package: DotNet46, from path: C:\ProgramData\Package Cache\83D048D171FF44A3CAD9B422137656F585295866\
[287C:2500][2016-10-12T09:32:21]: Unable to remove cached package: DotNet46, from path: C:\ProgramData\Package Cache\83D048D171FF44A3CAD9B422137656F585295866\, reason: 0x80070003. Continuing...
[2308:24BC][2016-10-12T09:32:21]: Error 0x80072ee7: Failed while caching, aborting execution.
[287C:2C64][2016-10-12T09:32:21]: Removed bundle dependency provider: {2e9e05c8-ae49-4af6-9121-fa821d1b5334}
[287C:2C64][2016-10-12T09:32:21]: Removing cached bundle: {2e9e05c8-ae49-4af6-9121-fa821d1b5334}, from path: C:\ProgramData\Package Cache\{2e9e05c8-ae49-4af6-9121-fa821d1b5334}\
[2308:24BC][2016-10-12T09:32:22]: Apply complete, result: 0x80072ee7, restart: None, ba requested restart:  No

Answer

MLguy picture MLguy · May 2, 2017

neera's answer did not worked form me. Another possible solution to the connection problem ('Failed to send request to URL') is to install SSDT from a .iso, but this is not trivial when working in a virtual machine.

Diagnosis: During the installation process of SSDT, a few components are supposed to be downloaded (i.e. the link in your log file represents one of those). Your virtual machine attempts to download such files through Internet Explorer (IE). However, by default the IE Enhanced Security Option is enabled. As a result, this stops you from downloading the required tools.

Solution: Log in your virtual machine, launch "Server Manager", select "Local Server" on the left, turn off "IE Enhanced Security Configuration".