FIX: "Encryption not supported on the client" error when a SQL Server 2017 linked server query fails

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Consider the following scenario:

  • You have an instance of Microsoft SQL Server 2017 that has a server setup that's linked to another instance of SQL Server.
  • A user without Bypass traverse checking local policy rights runs the first linked server query after a restart of the SQL Server service.

In this scenario, the initial linked server query is run, and every successive linked server query by any user returns error messages that resemble the following:

Resolution


This problem is fixed in the following update for SQL Server:

Cumulative Update 12 for SQL Server 2017

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 standard terminology Microsoft uses to describe software updates.