SSRS
SQL Server Reporting Services
Do not install SSRS on the SQL Server machine unless you have a good reason.Â
A good reason would be something like... you can't get budget to license a separate machine and you are licensed per individual virtual machine rather than per physical server with software assurance (aka "Maximum Virtualisation"). i.e. it's better to take a performance hit than run improperly licensed software.It makes performance troubleshooting more difficult
It makes patching and upgrades more difficult
It makes HA more difficult
Install on a dedicated machine if you can.
Bibliography
Bibliography
https://www.vkernel.ro/blog/install-and-configure-sql-server-reporting-services-ssrshttps://www.brentozar.com/archive/2019/02/should-you-run-ssas-ssis-ssrs-on-the-sql-server/
https://www.mssqltips.com/sqlservertip/3659/sql-server-reporting-services-best-practices-for-performance-and-maintenance/https://www.mssqltips.com/sqlservertip/4020/sql-server-reporting-services-general-best-practices/https://www.mssqltips.com/sqlservertip/6077/sql-server-reporting-services-what-i-wish-i-knew-when-i-started/https://www.mssqltips.com/sqlservertip/6638/install-ssrs/
https://ask.sqlservercentral.com/questions/41624/ssrs-best-practice.htmlhttps://www.sqlshack.com/configure-sql-server-reporting-services-databases-in-sql-server-always-on-availability-groups/
https://stackoverflow.com/questions/18068061/ssrs-must-excel-be-installed-on-reporting-server-to-use-excel-as-a-data-source
https://www.mssqltips.com/sqlservertip/3659/sql-server-reporting-services-best-practices-for-performance-and-maintenance/https://www.mssqltips.com/sqlservertip/4020/sql-server-reporting-services-general-best-practices/https://www.mssqltips.com/sqlservertip/6077/sql-server-reporting-services-what-i-wish-i-knew-when-i-started/https://www.mssqltips.com/sqlservertip/6638/install-ssrs/
https://ask.sqlservercentral.com/questions/41624/ssrs-best-practice.htmlhttps://www.sqlshack.com/configure-sql-server-reporting-services-databases-in-sql-server-always-on-availability-groups/
https://stackoverflow.com/questions/18068061/ssrs-must-excel-be-installed-on-reporting-server-to-use-excel-as-a-data-source