If we want to install SQL server SSRS service on another server separating it from the data source database server, what is the better option for installation? Option 1 or 2?
- to install SSRS service on a separate box, and also with database engine on same box, that hosts only reportdb and reportTempdb. and other system databases.
- to intall SSRS service on a sperate box that without database engine, but leave the ReportDB and ReportTempdb on a SQl server that has other data source databases on it.
In both cases, I understand the two servers need to be licensed, so license wise is the same. But I would like to know what is the best option regarding other aspects such as best practice, performance etc.