| title | Install SQL Server machine learning components without internet access | Microsoft Docs |
|---|---|
| ms.prod | sql |
| ms.technology | machine-learning |
| ms.date | 05/02/2018 |
| ms.topic | conceptual |
| author | HeidiSteen |
| ms.author | heidist |
| manager | cgronlun |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]
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.
[!INCLUDEGetInstallationMedia]
Note
For local installations, you must run Setup as an administrator. If you install [!INCLUDEssNoVersion] from a remote share, you must use a domain account that has read and execute permissions on the remote share.
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.
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 |
| SQL Server 2017 CU5 | |
| Microsoft R Open | no change; use previous |
| Microsoft R Server | SRS_9.2.0.500_1033.cab |
| Microsoft Python Open | no change; use previous |
| Microsoft Python Server | SPS_9.2.0.500_1033.cab |
| SQL Server 2017 CU6 | |
| Microsoft R Open | no change; use previous |
| Microsoft R Server | SRS_9.2.0.600_1033.cab |
| Microsoft Python Open | no change; use previous |
| Microsoft Python Server | SPS_9.2.0.600_1033.cab |
| SQL Server 2017 CU7 | |
| Microsoft R Open | no change; use previous |
| Microsoft R Server | o change; use previous |
| Microsoft Python Open | no change; use previous |
| Microsoft Python Server | no change; use previous |
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
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 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.
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.
-
Start the SQL Server setup wizard.
-
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.
-
In the Offline installation page, in Install Path, specify the folder containing the .cab files you copied earlier.
-
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 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.
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.
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.