Creating an Administrative Install for SSDT

Last update March 6 2012

There are many occasions where users will not be able to install SSDT directly from the web; company regulations, restricted bandwidth or simply because you are in a DMZ. For all these situations the “administrative install” capabilities of SSDT are there to provide the solution.

The administrative install enables you to create a completely independent installation point, which you can place on a flash drive or publish to a file share. Users can then install SSDT from this alternative location instead of having to download it from the web. This is also an ideal solution for engineers or consultants who want to make certain that they have their complete tool set with them at all times or if you want to burn an ISO image.

Lets walk through the steps required to create an administrative install.

  1. Create a local directory in which you are going to gather all the files. For this example we will create a directory named C:\SSDTAdminInstall.
  2. Next download the SSDT installer (SSDTSetup.exe) and save it in the C:\SSDTAdminInstall directory. Note that the SSDTSetup.exe file is language specific!

    Portuguese (Brazil)

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×416

    Chinese(PRC)

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×804

    English(United States)

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×409

    French

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0x40c

    German

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×407

    Italian

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×410

    Japanese

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×411

    Korean

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×412

    Russian

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×419

    Spanish

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0x40a

    Chinese(Taiwan)

    http://go.microsoft.com/fwlink/?LinkID=241405&clcid=0×404

  3. Start an elevated command shell and set the directory context to the C:\SSDTAdminInstall directory
  4. You can always execute “SSDTSetup.exe /?” to get the help screenimage
  5. Next we need to download all the files needed to create the independent and isolated administrative setup. We do this by executing: “SSDTSetup.exe /layout C:\SSDTAdminInstall”image
  6. This step launches a user interface which allows you to monitor the download progress.image
  7. When the download step is finished, the following files will reside in the C:\SSDTAdminInstall directory.

    C:\SSDTAdminInstall\SSDTSetup.exe

    C:\SSDTAdminInstall\payload\dotNetFx40_Full_x86_x64.exe

    C:\SSDTAdminInstall\payload\NDP40-KB2544514-x86-x64.exe

    C:\SSDTAdminInstall\payload\x64\DACFramework.msi

    C:\SSDTAdminInstall\payload\x64\NDP40-KB2468871-v2-x64.exe

    C:\SSDTAdminInstall\payload\x64\SharedManagementObjects.msi

    C:\SSDTAdminInstall\payload\x64\SQLDom.msi

    C:\SSDTAdminInstall\payload\x64\SqlLocalDB.msi

    C:\SSDTAdminInstall\payload\x64\sqlls.msi

    C:\SSDTAdminInstall\payload\x64\SQLSysClrTypes.msi

    C:\SSDTAdminInstall\payload\x64\TSqlLanguageService.msi

    C:\SSDTAdminInstall\payload\x86\DACFramework.msi

    C:\SSDTAdminInstall\payload\x86\NDP40-KB2468871-v2-x86.exe

    C:\SSDTAdminInstall\payload\x86\SharedManagementObjects.msi

    C:\SSDTAdminInstall\payload\x86\SQLDom.msi

    C:\SSDTAdminInstall\payload\x86\SqlLocalDB.msi

    C:\SSDTAdminInstall\payload\x86\sqlls.msi

    C:\SSDTAdminInstall\payload\x86\SQLSysClrTypes.msi

    C:\SSDTAdminInstall\payload\x86\SSDTDBSvcExternals.msi

    C:\SSDTAdminInstall\payload\x86\TSqlLanguageService.msi

    C:\SSDTAdminInstall\payload\x86\VS10sp1-KB983509.exe

    C:\SSDTAdminInstall\payload\x86\VSIntShell.exe

    C:\SSDTAdminInstall\ssdt\x86\DbSqlPackageProvider.msi

    C:\SSDTAdminInstall\ssdt\x86\SSDT.msi

    C:\SSDTAdminInstall\ssdt\x86\SSDTBuildUtilities.msi

  8. The administrative install is now ready to be used. You can start install SSDT by invoking C:\SSDTAdminInstall\SSDTSetup.exe.

Enjoy,
-GertD

This entry was posted in SETUP, SSDT and tagged . Bookmark the permalink.

Leave a Reply