FIX: Expression-based connection string is cleared out when you configure data sources for the report in SSRS 2016

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

Symptoms


Consider the following scenario:

  • You use Microsoft SQL Server 2016 Reporting Services (SSRS 2016).
  • You upload a report that contains an expression-based connection string to the SSRS, and configure the data source settings.
  • When you try to save the credentials in the data source setting, you may notice that the text box that contains the expression-based connection string will be cleared out and the report fails to run.

Resolution


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

       Cumulative update 8 for SQL Server 2016 SP1

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.