FIX: Upgrading SP1 instance fails when you use SxS instances of SQL Server 2016 SP1 and SP2

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

Symptoms


Assume that you have side-by-side (SxS) instances of Microsoft SQL Server 2016 Service Pack 1 (SP1) and Service Pack 2 (SP2) installed. You will be unable to upgrade the SP1 instance because the Cumulative Update (CU) patches for SP2 is missing RsFx0412 system driver.

Note Please ensure that the SxS instances of SQL Server 2016 SP2 instance have the latest updates before you upgrade the SQL Server 2016 SP1 instance.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 3 for SQL Server 2016 SP2

Workaround


To work around this issue, you can process the following steps:

  1. Extract RsFx.msi from the SP1 CU installer (/x option).
  2. Extract the contents of RsFx.msi (msiexec /a RSFX.MSI /qb TARGETDIR="C:\rsfx_content").
  3. Find RsFx0412.inf and RsFx0412.sys.
  4. Copy the files to: 
    1. C:\Program Files\Microsoft SQL Server\130\Shared\RsFxInstall\RsFx0412.inf and 
    2. C:\Windows\System32\Drivers\RsFx0412.sys.
  5. Restart the SP1 CU installer.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.