SQL Reporting Server Requirements

  • Enable the .NET Framework 3.5 by using the Add Roles and Features Wizard. For details, see https://technet.microsoft.com/en-in/library/dn482071.aspx
  • If SSL is enabled on the Report server, verify that the certificate name in the Issued To field is seen in the URL when accessing reports as follows:
    • Enter the fully qualified domain name (FQDN) of the IIS server into the Common name field. Internet Explorer compares the certificate common name to the server name specified in the URL when accessing a web site over a Secure Sockets Layer (SSL) connection. If the certificate common name and the server name in the URL do not match, Internet Explorer displays a certificate warning error message.
  • For SQL server versions 2008 R2, 2012 and 2014, the default collation setting on the ReportServer/ ReportServerTempDB databases is 'Latin1_General_CI_AS_KS_WS'. This is supported and must not be changed.
  • For SQL version 2016, the default collation setting on the ReportServer/ ReportServerTempDB databases is 'Latin1_General_100_CI_AS_KS_WS'.
  • For SQL version 2017 and 2019, the default collation setting on the ReportServer/ ReportServerTempDB databases is 'Latin1_General_100_CI_AS_KS_WS'.