SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components

SQL
20 Comments

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.

SQL SERVER - Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components setup-offline-01

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.

SQL SERVER - Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components setup-offline-02

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.

Here are the URLs which would come when “Python” is selected.

Hope this would help someone and save time which I spent in finding the behavior/solution.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Machine Learning, SQL Error Messages, SQL Server, SQL Server Installation, Starting SQL
Previous Post
SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect
Next Post
SQL SERVER – FIX: Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component ‘Ad Hoc Distributed Queries’

Related Posts

20 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

    Reply
  • 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!

    Reply
  • 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 ?

    Reply
  • Thank You sooo much! :)

    Reply
  • Driss EL FIGHAELFIGHA
    April 12, 2020 5:17 pm

    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

    Reply
  • LUPE S FERNANDEZ
    April 12, 2020 9:48 pm

    not working this solution

    Reply
  • 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

    Reply
  • Hi Thanks for the solution, worked well after downloading and setting the path for R :)

    Reply
  • Vandana Maurya
    May 21, 2021 10:10 pm

    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.”

    Reply
  • Wasted hours trying to upgrade a server, putting the Cab files locally worked, and yes I had extracted one first!!

    Thanks

    Reply
  • This worked for me. Thank you!

    Reply
  • Lol Thank you it worked

    Reply
  • vozcomotrompeta
    June 17, 2022 3:56 am

    Funciona a la perfección
    . Muchas gracias!!

    Reply
  • 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 :)

    Reply
  • Gosh! Placing all the CAB files in a single folder (with any arbitrary name) and specifying that name enabled the Next button! Thanks all!

    Reply
  • Worked like a charm! Thank you much

    Reply
  • Following the links provided in my own case, I downloaded all the files (4 files) and saved them in a folder which was now selected as the path. It resolved it for me. Thanks.

    Reply

Leave a Reply