How to install Sql Server Data Tools (SSDT) 2017 Offline (Internal Network installation)

Published Feb 10 2019 05:24 PM 83.2K Views
Microsoft

First published on MSDN on Jun 21, 2018

 

Before you begin:

The Official SQL Server SSDT Doc  contains updated information on these steps. I am keeping this blog as a reference at this point, though it is updated as well

 

 

Here is a request that came up recently:

"When installing SSDT manually it downloads a shell copy of Visual Studio 2017 from the Internet. However, if I get the offline copy of SSDT for VS2017 it does not include the Shell copy of VS2017 so the install fails because no Visual Studio 2017 instance is present. I need this for an internal network installation either via SCCM or wide unattended distribution."


This request makes sense for a lot of large enterprises where internet access may be restricted for security considerations.

Steps to accomplish this:

The overall approach is to download the required files on a computer that does have internet access. Then later use those bits on an internal network to install on multiple computers that do not have internet access.

1. Download SSDT standalone installer for VS 2017 (pick a language of your choice from the list) 

2. Download   Visual Studio Shell (vs_sql.exe)  also known as VS SQL SKU 

 

3. From a Command Prompt go to the folder where vs_sql.exe was downloaded and execute the following command on a machine with internet connection so you can download all the bits required for a later use offline. Using the --layout option is the key. For more details, see https://docs.microsoft.com/en-us/visualstudio/install/create-a-network-installation-of-visual-studi...

 

vs_sql.exe --layout c:\vs2017offline --lang en-US

 

Note: Above is for US English only ~1GB of files as an example.

 

3.1 If you need ALL languages downloaded you can use this command

 

vs_sql.exe --layout c:\vs2017offline

 

Note: all languages files add up to about ~3.9GB

4. Now, that you have all the necessary bits downloaded you can copy them to a network location or media so you can use them for offline (internal) installation

5. Next, to install offline, run this command which will install VS2017 Shell and SQL Server Data Project

 

vs_setup.exe --NoWeb

 

5.1 For no-GUI install, you can use

 

vs_setup.exe --NoWeb --wait --norestart --quiet

 

6. Run this for an interactive/GUI installation (be sure to select SSIS/SSRS/SSAS)

 

SSDT-Setup-ENU.exe /install

 

6.1 For an unattended installation to all VS Instances run

 

SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive /log log.txt

 

6.2 For an unattended installation to a specific VS Instance, you can query the instance ID of the desired VS instance

 

cd C:\Program Files (x86)\Microsoft Visual Studio\Installer
C:\Program Files (x86)\Microsoft Visual Studio\Installer> vswhere.exe -all

 

  Then run this command by replacing the VS_INSTANCE_ID_HERE with your instanceID (it will look something like this: 49cf420b)

 

SSDT-Setup-ENU.exe /INSTALLALL[:VS_INSTANCE_ID_HERE] /passive

 

 

Note: For detailed command options, you can run 

 

SSDT-Setup-ENU.exe /help 

 

 

You will see on that screen the following: 

JosephPilov_0-1634062320519.png

 

 

Thanks to Paritosh Soni for the contribution on vswhere.exe and installing for a specific instanceID, testing and helping improve this post overall.

 

 

6 Comments
Senior Member
Thank you very much Joseph pilov, not only for this content related but for all the consolidated guides and troubleshootng steps under one roof in few clicks.
Occasional Visitor

I am having trouble in following the steps of installing the ssdt offline...I am already done in steps 1-3.Can you please elaborate it.. sorry i am just new to this type of method

Visitor

When I try to download the vsix files for SSDT it errors out for Integration Services.  Looking at another article it reference this web address to download the file, but I get the error "404 - File or directory not found"  Has Microsoft changed the download location?

  

 

 

Visitor

Forgot to paste the url:  Microsoft.DataTools.IntegrationServices: https://go.microsoft.com/fwlink/?LinkId=871369

Occasional Visitor

I downloaded both SSDT-Setup-ENU.exe and vs_sql.exe but always required internet for intallation. I am new this kind of installation and please i need comprehensive guide for the installation

Microsoft

Folks thanks for reporting the problem with installation. I reproduced the problem and examined the log file

 

JosephPilov_0-1634058468144.png

 

[0B9C:3BD4][2021-10-12T12:07:18]e000: Error 0x80070002: Failed attempt to download URL: 'https://go.microsoft.com/fwlink/?LinkId=874726' to: 'C:\Users\joseph\AppData\Local\Temp\{7D87F596-B564-4EC7-BABE-06EFFF5EFBBF}\VCRedist2010'
[0B9C:3BD4][2021-10-12T12:07:18]e000: Error 0x80070002: Failed to acquire payload from: 'https://go.microsoft.com/fwlink/?LinkId=874726' to working path: 'C:\Users\joseph\AppData\Local\Temp\{7D87F596-B564-4EC7-BABE-06EFFF5EFBBF}\

 

The issue is that the URL https://go.microsoft.com/fwlink/?LinkId=874726 is no longer valid.

 

Solution: 

The SSDT-Setup-ENU.exe has been updated to contain all the information inside it and is therefore a larger file. But you can follow the steps on DOCs for offline install which will allow you to proceed successfully

The instructions above have also been updated as of this Comment

%3CLINGO-SUB%20id%3D%22lingo-sub-334020%22%20slang%3D%22en-US%22%3EHow%20to%20install%20Sql%20Server%20Data%20Tools%20(SSDT)%202017%20Offline%20(Internal%20Network%20installation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334020%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jun%2021%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EHere%20is%20a%20request%20that%20came%20up%20recently%3A%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%22When%20installing%20SSDT%20manually%20it%20downloads%20a%20shell%20copy%20of%20Visual%20Studio%202017%20from%20the%20Internet.%20However%2C%20if%20I%20get%20the%20%3CSTRONG%3E%20offline%20%3C%2FSTRONG%3E%20copy%20of%20SSDT%20for%20VS2017%20it%20does%20not%20include%20the%20Shell%20copy%20of%20VS2017%20so%20the%20install%20fails%20because%20no%20Visual%20Studio%202017%20instance%20is%20present.%20I%20need%20this%20for%20an%20internal%20network%20installation%20either%20via%20SCCM%20or%20wide%20unattended%20distribution.%22%3C%2FBLOCKQUOTE%3E%0A%3CP%3E%3CBR%20%2F%3EThis%20request%20makes%20sense%20for%20a%20lot%20of%20large%20enterprises%20where%20internet%20access%20may%20be%20restricted%20for%20security%20considerations.%20%3CBR%20%2F%3E%3CBR%20%2F%3ESteps%20to%20accomplish%20this%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20overall%20approach%20is%20to%20download%20the%20required%20files%20on%20a%20computer%20that%20does%20have%20internet%20access.%20Then%20later%20use%20those%20bits%20on%20an%20internal%20network%20to%20install%20on%20multiple%20computers%20that%20do%20not%20have%20internet%20access.%20%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D874716%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDownload%20SSDT%20for%20VS%202017%20%3C%2FA%3E%20(standalone%20installer)%20see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssdt%2Fdownload-sql-server-data-tools-ssdt%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssdt%2Fdownload-sql-server-data-tools-ssdt%3Fview%3Dsql-server-2017%20%3C%2FA%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fvs%2F15%2Frelease%2Fvs_sql.exe%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDownload%20%3C%2FA%3E%20VS%20SQL%20SKU%20-%20this%20is%20essentially%20the%20Visual%20Studio%20Shell%20(vs_sql.exe)%20%3CBR%20%2F%3E3.%20From%20a%20Command%20Prompt%20go%20to%20the%20folder%20where%20vs_sql.exe%20was%20downloaded%20and%20execute%20the%20following%20command%20on%20a%20machine%20with%20internet%20connection%20so%20you%20can%20download%20all%20the%20bits%20required%20for%20a%20later%20use%20offline.%20Using%20the%20--layout%20option%20is%20the%20key.%20For%20more%20details%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fvisualstudio%2Finstall%2Fcreate-a-network-installation-of-visual-studio%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fvisualstudio%2Finstall%2Fcreate-a-network-installation-of-visual-studio%20%3C%2FA%3E%20%3CBR%20%2F%3Evs_sql.exe%20--layout%20c%3A%5Cvs2017offline%20--lang%20en-US%20%3CBR%20%2F%3ENote%3A%20above%20is%20for%20US%20English%20only%20~1GB%20of%20files%20%3CBR%20%2F%3E%3CBR%20%2F%3EAlternatively%2C%20if%20you%20need%20ALL%20languages%20downloaded%20you%20can%20use%20this%20command%20%3CBR%20%2F%3Evs_sql.exe%20--layout%20c%3A%5Cvs2017offline%20%3CBR%20%2F%3ENote%3A%20all%20languages%20files%20add%20up%20to%20about%20~3.9GB%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CEM%3E%20Now%2C%20that%20you%20have%20all%20the%20necessary%20bits%20downloaded%20you%20can%20copy%20them%20to%20a%20network%20location%20or%20media%20so%20you%20can%20use%20them%20for%20offline%20(internal)%20installation%20%3C%2FEM%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E4.%20Next%2C%20to%20install%20offline%2C%20run%20this%20command%20which%20will%20install%20VS2017%20Shell%20and%20SQL%20Server%20Data%20Project%20%3CBR%20%2F%3Evs_setup.exe%20--NoWeb%20%3CBR%20%2F%3EAlternatively%2C%20for%20no-GUI%20install%20%2C%20you%20can%20use%20%3CBR%20%2F%3Evs_setup.exe%20--NoWeb%26nbsp%3B--wait%20--norestart%20--quiet%20%3CBR%20%2F%3E5.%20Execute%20the%20%2Flayout%20option%20for%20SSDT%20to%20download%20and%20extract%20all%20the%20files%20needed%20for%20an%20offline%20installation%20%3CBR%20%2F%3ESSDT-Setup-ENU.exe%20%2Flayout%20c%3A%5Cssdt_install_bits%20%3CBR%20%2F%3E6.%20Run%20this%20for%20an%20interactive%2FGUI%20installation%20(be%20sure%20to%20select%20SSIS%2FSSRS%2FSSAS)%20%3CBR%20%2F%3ESSDT-Setup-ENU.exe%20%3CBR%20%2F%3EAlternatively%20for%20an%20unattended%20installation%20run%20%3CBR%20%2F%3ESSDT-Setup-ENU.exe%20%2FINSTALLALL%5B%3Avsinstances%5D%20%2Fpassive%20%2Flog%20log.txt%20%3CBR%20%2F%3ENote%3A%20SSDT-Setup-ENU.exe%20%2Fhelp%20can%20be%20run%20for%20detailed%20command%20options%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3E%20Note%20%3C%2FSTRONG%3E%20%3A%20We%20have%20updated%20the%20official%20SQL%20Server%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssdt%2Fdownload-sql-server-data-tools-ssdt%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20SSDT%20Doc%20%3C%2FA%3E%20with%20the%20above%20information%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-334020%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20MSDN%20on%20Jun%2021%2C%202018%20Here%20is%20a%20request%20that%20came%20up%20recently%3A%22When%20installing%20SSDT%20manually%20it%20downloads%20a%20shell%20copy%20of%20Visual%20Studio%202017%20from%20the%20Internet.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-334020%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Esetup%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUtilities%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-481957%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20install%20Sql%20Server%20Data%20Tools%20(SSDT)%202017%20Offline%20(Internal%20Network%20installation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481957%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much%20Joseph%20pilov%2C%20not%20only%20for%20this%20content%20related%20but%20for%20all%20the%20consolidated%20guides%20and%20troubleshootng%20steps%20under%20one%20roof%20in%20few%20clicks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1241786%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20install%20Sql%20Server%20Data%20Tools%20(SSDT)%202017%20Offline%20(Internal%20Network%20installation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1241786%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20trouble%20in%20following%20the%20steps%20of%20installing%20the%20ssdt%20offline...I%20am%20already%20done%20in%20steps%201-3.Can%20you%20please%20elaborate%20it..%20sorry%20i%20am%20just%20new%20to%20this%20type%20of%20method%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491102%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20install%20Sql%20Server%20Data%20Tools%20(SSDT)%202017%20Offline%20(Internal%20Network%20installation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491102%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20download%20the%20vsix%20files%20for%20SSDT%20it%20errors%20out%20for%20Integration%20Services.%26nbsp%3B%20Looking%20at%20another%20article%20it%20reference%20this%20web%20address%20to%20download%20the%20file%2C%20but%20I%20get%20the%20error%20%22404%20-%20File%20or%20directory%20not%20found%22%26nbsp%3B%20Has%20Microsoft%20changed%20the%20download%20location%3F%3C%2FP%3E%3CH2%20id%3D%22toc-hId-1703718244%22%20id%3D%22toc-hId-1703718244%22%20id%3D%22toc-hId-1703718244%22%20id%3D%22toc-hId-1703718244%22%20id%3D%22toc-hId-1703718244%22%3E%26nbsp%3B%26nbsp%3B%3C%2FH2%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId--651925212%22%20id%3D%22toc-hId--651925212%22%20id%3D%22toc-hId--651925212%22%20id%3D%22toc-hId--651925212%22%20id%3D%22toc-hId--651925212%22%3E%26nbsp%3B%3C%2FH1%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492244%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20install%20Sql%20Server%20Data%20Tools%20(SSDT)%202017%20Offline%20(Internal%20Network%20installation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492244%22%20slang%3D%22en-US%22%3E%3CP%3EForgot%20to%20paste%20the%20url%3A%26nbsp%3B%26nbsp%3B%3CSPAN%3EMicrosoft.DataTools.IntegrationServices%3A%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D871369%22%20rel%3D%22noreferrer%20noopener%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D871369%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1717073%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20install%20Sql%20Server%20Data%20Tools%20(SSDT)%202017%20Offline%20(Internal%20Network%20installation)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717073%22%20slang%3D%22en-US%22%3E%3CP%3EI%20downloaded%20both%20SSDT-Setup-ENU.exe%20and%20vs_sql.exe%20but%20always%20required%20internet%20for%20intallation.%20I%20am%20new%20this%20kind%20of%20installation%20and%20please%20i%20need%20comprehensive%20guide%20for%20the%20installation%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Oct 18 2021 11:21 AM
Updated by: