locked
Installing SSRS 2016 on a separate server than the SQL database RRS feed

  • Question

  • Hi All,


    I've been reading through the documentation online, but cannot locate anything related to this. Is it okay to install SSRS on a server that isn't running SQL (database agent, engine, etc.)? We currently have SSRS and SQL database running on the same server. However, the vendor wants us to move SSRS to a completely separate server. I'm guessing the reporting database would still stay on the current SQL box, but the SSRS application along with RDLs, etc. would be installed on an entirely separate server. Is this possible? And if so, can anyone point to any documentation or advice on this? I've been looking but haven't found much yet. I appreciate any help!

    Friday, August 10, 2018 1:54 PM

Answers

All replies

  • The configuration we see the most is to install SSRS on a separate server (a dedicated Reporting Services Server) rather than on the server (instance) your User databases live in order to separate processing power and administration.  The two Reporting databases that SSRS creates can live anywhere, but for us, it made sense to simply install them on the same Reporting Server as a default Sql Server instance. This configuration works well for us.
    Friday, August 10, 2018 2:56 PM
  • It's OK to install SSRS on a different server. It doesn't have to share the same server as the Database. However, the general practice is to keep the report server local and have "ReportServer" and "ReportServerTempDB" on the local SQL instance. You can point your report server to the ReportServer DBs on a remote instance in the reporting server configuration manager. 

    The following should help:

    https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-native-mode-report-server-database?view=sql-server-2017#to-create-a-local-report-server-database

    https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database?view=sql-server-2017


    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Friday, August 10, 2018 3:12 PM
  • Still on the same subject, can SQL Server 2017 installed on a separate server be used to host SSRS 2016 databases? The article below only mentions support up to SQL Server 2016.

    https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database?view=sql-server-2017#database-server-version-requirements


    SQL Server Database Administrator

    Wednesday, October 17, 2018 3:40 AM
  • Still on the same subject, can SQL Server 2017 installed on a separate server be used to host SSRS 2016 databases? The article below only mentions support up to SQL Server 2016.

    https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database?view=sql-server-2017#database-server-version-requirements

    While I have not tried that configuration myself but I don't see a reason why it would not work. 

    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Wednesday, October 17, 2018 3:59 AM
  • Thanks, Mohsin. Your previous answer did the trick. I marked it an the answer due to the helpful documentation.
    Thursday, October 18, 2018 1:52 PM