Home
%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
Microsoft

First published on MSDN on Jun 21, 2018
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 for VS 2017 (standalone installer) see https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

2. Download VS SQL SKU - this is essentially the Visual Studio Shell (vs_sql.exe)
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

Alternatively, 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

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

4. Next, to install offline, run this command which will install VS2017 Shell and SQL Server Data Project
vs_setup.exe --NoWeb
Alternatively, for no-GUI install , you can use
vs_setup.exe --NoWeb --wait --norestart --quiet
5. Execute the /layout option for SSDT to download and extract all the files needed for an offline installation
SSDT-Setup-ENU.exe /layout c:\ssdt_install_bits
6. Run this for an interactive/GUI installation (be sure to select SSIS/SSRS/SSAS)
SSDT-Setup-ENU.exe
Alternatively for an unattended installation run
SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive /log log.txt
Note: SSDT-Setup-ENU.exe /help can be run for detailed command options



Note : We have updated the official SQL Server SSDT Doc with the above information

1 Comment
Established 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.