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?
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.
Thanks,
My preference is option 1 - as it separates SSRS from all data source systems. It can be upgraded independently from any other data source and isn't tied to one specific application or SQL instance. Since reports can be deployed and access any data source - of any type with an ODBC driver - it just doesn't make sense to tie the solution to a single applications database engine.
The only time I would consider separating the database engine from the reporting services is in a scale-out deployment. And for that I would have a dedicated database engine instance for the scale-out solution, with a server for the db engine and multiple servers for the web components.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 15, 2021 at 9:02 pm
Thank you, yes option 1 is my preferred too, thanks for explaining that clearly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply