Install SQL Server machine learning components without internet access

THIS TOPIC APPLIES TO: yesSQL Server (Windows only)noAzure SQL DatabasenoAzure SQL Data WarehousenoParallel Data Warehouse

By default, installers connect to Microsoft download sites to get required and updated components for machine learning on SQL Server. If firewall constraints prevent the installer from reaching these sites, you can use an internet-connected device to download files, transfer files to an offline server, and then run setup.

Get the installation media

The download location for SQL Server depends on the edition:

  • SQL Server Enterprise, Standard, and Express Editions are licensed for production use. For Enterprise and Standard Editions, contact your software vendor for the installation media. You can find purchasing information and a directory of Microsoft partners on the Microsoft purchasing website.

  • Free editions are available at SQL Server Downloads.

Note

For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.

Install patch requirement

Microsoft has identified a problem with the specific version of Microsoft VC++ 2013 Runtime binaries that are installed as a prerequisite by SQL Server. If this update to the VC runtime binaries is not installed, SQL Server may experience stability issues in certain scenarios. Before you install SQL Server follow the instructions at SQL Server Release Notes to see if your computer requires a patch for the VC runtime binaries.

Download .cab files

On an internet-connected server, download the .cab files required for an offline installation. The setup program uses the .cab files to install supplemental features.

Release Download link
SQL Server 2017 initial release
Microsoft R Open SRO_3.3.3.24_1033.cab
Microsoft R Server SRS_9.2.0.24_1033.cab
Microsoft Python Open SPO_9.2.0.24_1033.cab
Microsoft Python Server SPS_9.2.0.24_1033.cab
SQL Server 2017 CU1
Microsoft R Open no change; use previous
Microsoft R Server SRS_9.2.0.100_1033.cab
Microsoft Python Open no change; use previous
Microsoft Python Server SPS_9.2.0.100_1033.cab
SQL Server 2017 CU2
Microsoft R Open no change; use previous
Microsoft R Server no change; use previous
Microsoft Python Open no change; use previous
Microsoft Python Server no change; use previous
SQL Server 2017 CU3
Microsoft R Open SRO_3.3.3.300_1033.cab
Microsoft R Server SRS_9.2.0.300_1033.cab
Microsoft Python Open no change; use previous
Microsoft Python Server SPS_9.2.0.300_1033.cab
SQL Server 2017 CU4
Microsoft R Open no change; use previous
Microsoft R Server SRS_9.2.0.400_1033.cab
Microsoft Python Open no change; use previous
Microsoft Python Server SPS_9.2.0.400_1033.cab

Downloads for SQL Server 2016

Important

When installing SQL Server 2016 SP1 CU4 or SP1 CU5 offline, download SRO_3.2.2.16000_1033.cab. If you downloaded SRO_3.2.2.13000_1033.cab from FWLINK 831785 as indicated in the setup dialog box, rename the file as SRO_3.2.2.16000_1033.cab before installing the Cumulative Update.

Release Download link
SQL Server 2016 RTM
Microsoft R Open SRO_3.2.2.803_1033.cab
Microsoft R Server SRS_8.0.3.0_1033.cab
SQL Server 2016 CU 1
Microsoft R Open SRO_3.2.2.10000_1033.cab
Microsoft R Server SRS_8.0.3.10000_1033.cab
SQL Server 2016 CU 2
Microsoft R Open SRO_3.2.2.12000_1033.cab
Microsoft R Server SRS_8.0.3.12000_1033.cab
SQL Server 2016 CU 3
Microsoft R Open no change; use previous
Microsoft R Server no change; use previous
SQL Server 2016 CU 4
Microsoft R Open SRO_3.2.2.13000_1033.cab
Microsoft R Server SRS_8.0.3.13000_1033.cab
SQL Server 2016 CU 5
Microsoft R Open no change; use previous
Microsoft R Server no change; use previous
SQL Server 2016 CU 6
Microsoft R Open no change; use previous
Microsoft R Server SRS_8.0.3.14000_1033.cab
SQL Server 2016 CU 7
Microsoft R Open no change; use previous
Microsoft R Server no change; use previous
SQL Server 2016 SP 1
Microsoft R Open SRO_3.2.2.15000_1033.cab
Microsoft R Server SRS_8.0.3.15000_1033.cab
SQL Server 2016 SP 1 CU1
Microsoft R Open no change; use previous
Microsoft R Server no change; use previous
SQL Server 2016 SP 1 CU2
Microsoft R Open SRO_3.2.2.16000_1033.cab
Microsoft R Server SRS_8.0.3.16000_1033.cab
SQL Server 2016 SP 1 CU3
Microsoft R Open no change; use previous
Microsoft R Server no change; use previous
SQL Server 2016 SP 1 CU4 and GDR
Microsoft R Open no change; use previous
Microsoft R Server SRS_8.0.3.17000_1033.cab
SQL Server 2016 SP 1 CU5
Microsoft R Open no change; use previous
Microsoft R Server no change; use previous

If you would like to view the source code for Microsoft R, it is available for download as an archive in .tar format: Download R Server installers

Additional prerequisites

Depending on your environment, you might need to make local copies of installers for the following prerequisites.

Component Version
Microsoft AS OLE DB Provider for SQL Server 2016 13.0.1601.5
Microsoft .NET Core 1.0.1
Microsoft MPI 7.1.12437.25
Microsoft Visual C++ 2013 Redistributable 12.0.30501.0
Microsoft Visual C++ 2015 Redistributable 14.0.23026.0

Transfer files

Transfer the zipped SQL Server installation media and the files you already downloaded to the computer on which you are installing setup.

Put the CAB files in a convenient folder such as Downloads or the setup user's temp folder: C:\Users\AppData\Local\Temp.

Put the en_sql_server_2017.iso file in a convenient folder. Double-click setup.exe to begin installation.

Run Setup

When you run SQL Server setup on a computer disconnected from the internet, Setup adds an Offline installation page to the wizard so that you can specify the location of the .cab files you copied in the previous step.

  1. Start the SQL Server setup wizard.

  2. When the setup wizard displays the licensing page for open source R or Python components, click Accept. Acceptance of licensing terms allows you to proceed to the next step.

  3. In the Offline installation page, in Install Path, specify the folder containing the .cab files you copied earlier.

  4. Continue following the on-screen prompts to complete the installation.

After installation is finished, restart the service and then configure the server to enable script execution as described in Install SQL Server 2017 Machine Learning Services (In-Database) or Install SQL Server 2016 R Services (In-Database).

Slipstream upgrades for offline servers

Slipstream setup refers to the ability to apply a patch or update to a failed instance installation, to repair existing problems. The advantage of this method is that the SQL Server is updated at the same time that you perform setup, avoiding a separate restart later.

  • If the server does not have Internet access, you must download the SQL Server installer, and then download matching versions of the R component installers before beginning the update process. The R components are not included by default with SQL Server.

  • If you are adding these components to an existing installation, use the updated version of the SQL Server installer, and the corresponding updated version of the additional components. When you specify that the R feature is to be installed, the installer looks for the matching version of the installers for the machine learning components.

Get help

Need help with installation or upgrade? For answers to common questions and known issues, see the following article:

To check the installation status of the instance and fix common issues, try these custom reports.

This article by the R Services Support team demonstrates how to perform an unattended install or upgrade of R services in SQL Server 2016: Deploying R Services on Computers without Internet Access.

Next steps

R developers can get started with some simple examples, and learn the basics of how R works with SQL Server. For your next step, see the following links:

Python developers can learn how to use Python with SQL Server by following these tutorials:

To view examples of machine learning that are based on real-world scenarios, see Machine learning tutorials.