Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 7 – Manually configure Reporting Services

When you install standalone SQL Server (apply for standalone and also standalone for AlwaysOn Availability Groups) you can select Install and configure Reporting Services and installer does simple configuration of the Reporting Services that is suitable for most of the applications.

There is a reason why the default choice for Reporting Services during installation of the SQL Server on the node of the Failover Cluster (AlwaysOn Failover Cluster Instances) is Install only and not Install and configure. Even when you select Install and configure the installer is not able to configure the Reporting Service. You have to do that manually after installation.

Default choice during installation of the SQL Server AlwaysOn Failover Cluster Instances

  • Default choice Install only.
  • You cannot use Install and configure (you can but the Reporting Services will not be confiured).

Validate configuration

  • Check Report Server website: http://<Server name>:<Port>/ReportServer_<Instance>
    • http://contsqlfcic0n0:80/ReportServer_SCSMD0
    • Reporting Services are not running.
        • http://contsqlfcic0n0:80/ReportServer_SCSMD0
    • Wrong or incomplete configuration
        • http://contsqlfcic0n0:80/ReportServer_SCSMD0
    • Proper configuration
        • http://contsqlfcic0n0:80/ReportServer_SCSMD0
  • Check Report Manager website. http://<Server name>:<Port>/Reports_<Instance>
    • http://contsqlfcic0n0:80/Reports_SCSMD0
    • Reporting Services are not running.
        • http://contsqlfcic0n0:80/ReportServer_SCSMD0
    • Wrong or incomplete configuration
        • http://contsqlfcic0n0:80/ReportServer_SCSMD0
    • Proper configuration
        • http://contsqlfcic0n0:80/ReportServer_SCSMD0

Configure Reporting Services

  • Run Reporting Services Configuration Manager
  • Connect to instance with Reporting Services feature.
      • CONTSQLFCIC0N0\SCSMD0
  • Service Account
    • Check that service account was set.
  • Web Service URL
    • Click to Apply.
  • Report Manager URL
    • Click to Apply.
  • Database
    • You can check that databases do not exist.
        • contsqlfcic0sd0.ad.contoso.com\SCSMD0
    • Change Database
    • Create a new report server database.
    • Select SQL cluster (not the SQL node).
        • contsqlfcic0sd0.ad.contoso.com\SCSMD0
    • You can leave the default name.
        • ReportServer
    • Select Service Credentials.
    • Finish
    • You can check that the DB was created.

2 Comments on “Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 7 – Manually configure Reporting Services

  1. For setup of SSRS — do both DB’s need to be in AO — is there any risk of not keeping the reportserver temdb OUTSIDE of AO? It would seem this temp-db can be treated like the sql tempdb and left external to AO….please comment. Thanks

  2. For setup of SSRS — do both DB’s need to be in AO — is there any risk of not keeping the reportserver temdb OUTSIDE of AO? It would seem this temp-db can be treated like the sql tempdb and left external to AO….please comment. Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *