I was trying to install SQL Server 2017 on my latest formatted machine and was stuck at below screen which says – Offline Installation of Microsoft Machine Learning Server Components. In this blog, we would learn about how to move forward in the Installation when it is stuck at Offline Installation of Microsoft Machine Learning Server Components.
First let’s understand the cause the screen because when I was installing SQL with my client, I didn’t see this screen at all.
It looks like If we select Machine Learning, the setup would connect to the internet and download few components. If it is not able to reach to the internet, then it would provide above the screen.
I looked at Detail.txt and then RSetup.log and found below in RSetup.log.
2018-11-26T03:48:50 INFO Command invoked: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017\x64\RSetup.exe /checkurl /component SRS /version 9.2.0.24 /language 1033 /logfile C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20181125_193933\RSetup.log
2018-11-26T03:48:50 INFO RSetup.exe version: 9.2.0.44
2018-11-26T03:48:50 INFO Validating URL: https://rserverdistribution.azureedge.net/production/SRS/9.2.0.24/3013/1033/33f8d690e29044b4b6ff3d3989c8756d/SRS_9.2.0.24_1033.cab
2018-11-26T03:49:11 WARN Error making request: Unable to connect to the remote server
2018-11-26T03:49:11 WARN Error validating download
2018-11-26T03:49:11 INFO Exiting with code 851507
All it says that it is not able to reach to the internet and download the packages. This depends on what features were selected during the feature selection screen. A picture speaks a thousand words and below two images would explain what I mean.
https://blog.sqlauthority.com/i/d/setup-offline-03.jpg
WORKAROUND/SOLUTION
As explained in the message, we need to download ALL the files from ALL the link provided below and then keep them in some folder. Here are the links for your ready reference.
Here are the URLs which come when “R” is selected.
- https://go.microsoft.com/fwlink/?LinkId=851496&clcid=1033
- https://rserverdistribution.azureedge.net/production/SRS/9.2.0.24/3013/1033/33f8d690e29044b4b6ff3d3989c8756d/SRS_9.2.0.24_1033.cab
Here are the URLs which would come when “Python” is selected.
- https://go.microsoft.com/fwlink/?LinkId=851502&clcid=1033
- https://go.microsoft.com/fwlink/?LinkId=851508&clcid=1033
Hope this would help someone and save time which I spent in finding the behavior/solution.
Reference: Pinal Dave (https://blog.sqlauthority.com)
18 Comments. Leave new
It should be unticked from the Shared Features section (and not Instance Features), I believe. Got it running now with that.
And with Shared Features, no amount of downloading and providing folder path would enable the Next button
Downloading all modules from the links above resolved the issue on my PC: the Next button became enabled, and installation of SQL Server 2017 with all shared components succeeded. Thanks for the helpful post!
After installing the 2 files for R and 2 files for Python:
(1) In which folder should I place them so that the SQL Server installation wizard can access them and the “Next” button gets enabled to proceed installation.
(2) The downloaded files are cab files. Do we need to extract them or use them as it is ?
I have the same questions. Please help?
Thank You sooo much! :)
I tried your solution on 3 différents server with a refresh windows installation. No one worked for me. I already lost 3 days with this problem. My conclusion is that I will no longer use SQL Server ML. IT’s simply a very very bad product
not working this solution
guys, make sure you have the right version of the files for the sql server version you’re installing. take a look at this documentation… https://docs.microsoft.com/en-us/sql/machine-learning/install/sql-ml-component-install-without-internet-access?view=sql-server-ver15
Hi Thanks for the solution, worked well after downloading and setting the path for R :)
Download EVERY file from each link provided – not negotiable
Each file you are downloading is a CAB file for a feature you elected to install
DO NOT extract the CAB files – it won’t help you at all and it takes a long time to do (yeah I did this)
Make sure ALL the CAB files are located in the same folder
When you are finished downloading the CAB files point the “Install Path” to the location where you downloaded the CAB files.
FYI: “Install path” does not mean installation path in this context. Instead it means “installation file location” or more specifically “cab file location”. Or in other words “Where can the SQL Server installer find the CAB files you just downloaded.”
It works like a charm – Thank you – took me 3 hours to find this trend.
Wasted hours trying to upgrade a server, putting the Cab files locally worked, and yes I had extracted one first!!
Thanks
This worked for me. Thank you!
Lol Thank you it worked
Funciona a la perfección
. Muchas gracias!!
Thanks for this, I didn’t notice the differences in the links initially and was stumped by it (there 4 now!). Got it all installed now :)
Gosh! Placing all the CAB files in a single folder (with any arbitrary name) and specifying that name enabled the Next button! Thanks all!
Worked like a charm! Thank you much