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'.