Symptoms
When you run a repair from SQL Server 2016 or 2017 installation media on a server which does not have Internet access, the repair operation fails for the Machine Learning components (for example, R, Python). However, repair succeeds for all other components including Machine Learning (In-Database).
The ‘rsetup.log’ confirms that the failure is due to a failed attempt to download the SRO/SRS and/or SPO/SPS components:
Date\Time INFO Command invoked: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017\x64\RSetup.exe /download /component SRO /version 3.3.3.24 /language 1033 /logfile C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190621_140530\RSetup.log
Date\Time INFO RSetup.exe version: 9.2.0.25
Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\Setup\R_SERV_CACHE
Date\Time INFO Registry value:
Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\BootstrapDir
Date\Time INFO Registry value: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\
Date\Time INFO Searching for cache dir: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\\R_SERV_CACHE
Date\Time INFO Using default cache directory: C:\Users\administrator.SQLREPRO\AppData\Local\Temp\
Date\Time INFO Starting download: https://go.microsoft.com/fwlink/?LinkId=851496&clcid=1033
Date\Time WARN Error making request: Unable to connect to the remote server
Date\Time ERROR Download failed: https://go.microsoft.com/fwlink/?LinkId=851496&clcid=1033 [Object reference not set to an instance of an object.]
Date\Time INFO Exiting with code 851496
Date\Time INFO Command invoked: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017\x64\RSetup.exe /download /component SPO /version 9.2.0.24 /language 1033 /logfile C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190621_140530\RSetup.log
Date\Time INFO RSetup.exe version: 9.2.0.25
Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\Setup\R_SERV_CACHE
Date\Time INFO Registry value:
Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\BootstrapDir
Date\Time INFO Registry value: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\
Date\Time INFO Searching for cache dir: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\\R_SERV_CACHE
Date\Time INFO Using default cache directory: C:\Users\administrator.SQLREPRO\AppData\Local\Temp\
Date\Time INFO Starting download: https://go.microsoft.com/fwlink/?LinkId=851502&clcid=1033
Date\Time WARN Error making request: Unable to connect to the remote server
Date\Time ERROR Download failed: https://go.microsoft.com/fwlink/?LinkId=851502&clcid=1033 [Object reference not set to an instance of an object.]
Date\Time INFO Exiting with code 851502
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Resolution
This issue is fixed in the following cumulative updates for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Workaround
To work around this issue, you can use one of the following methods:
-
The workaround is to run setup.exe via command-line and include the '/MRCACHEDIRECTORY' switch to specify the location of the cab files.
-
To place the manually downloaded SRO\SRS and/or SPO\SPS files under the default cache directory before you run Repair.
References
Learn about the terminology that Microsoft uses to describe software updates.
