FIX: Cannot install SQL Server R Services during an offline installation of SQL Server 2016 updates

Applies to: SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise


When you perform an offline installation of Microsoft SQL Server 2016 servicing update to an instance that has the R Services feature installed (no Internet access is available), you're not prompted to accept the Microsoft R licensing agreement, nor are you given the opportunity to specify an offline location of updated R Services CAB files. Therefore, after the reported successful installation of the SQL Server 2016 update, the R Services component has actually not been updated as expected.


How to obtain this hotfix update package

For SQL Server 2016 RTM

If you have not previously installed SQL Server 2016 RTM Cumulative Updates 1,2, or 3 (your current build number would be earlier than 13.0.2149.0), please reference either:
  • 3210111  GDR update package for SQL Server 2016 RTM, which will address the issues described below and only prior important GDR fixes released since SQL Server 2016 RTM, or
  • 3210110  On-demand hotfix for SQL Server 2016 CU3, which will address the issues described below as well as all cumulative hotfixes addressed in the latest SQL Server 2016 Cumulative Update
Cumulative Update 4 for SQL Server 2016

For SQL Server 2016 SP1

Please reference 3210089  GDR update package for SQL Server 2016 SP1.

Cumulative Update 2 for SQL Server 2016 SP1

Hotfix update package information

Restart information

You may have to restart the computer after you apply this hotfix update.

Registry information

To use one of the hotfixes in this package, you don't have to make any changes to the registry.