topic Restriction on the Report Server Deployment Server node? in Report Server

Restriction on the Report Server Deployment Server node?

mehmet-vrp — Fri, 28 May 2021 14:51:26 GMT

Hi all,

Suppose that we have a 4-core pack SQL Server Enterprise license. Do I need to run Power BI Report Server, SSIS ,SQL Server Analysis Services on the same server as SQL Server running on?

Can I deploy Power BI Report Server, SSIS, Analysis Services applications on different machines with higher number of cores?

Re: Restriction on the Report Server Deployment Server node?

v-deddai1-msft — Mon, 31 May 2021 02:56:05 GMT

Hi mehmet-vrp ,

>>Can I deploy Power BI Report Server, SSIS, Analysis Services applications on different machines with higher number of cores?

As far as I know you can do it. Divide your engine instances and ssas instances to different servers would be a perfect suggestion.

And please refer to https://www.sqlbi.com/articles/optimizing-memory-settings-in-analysis-services/ to optimize the ssas.

And pay attention to If you're creating the report server database on a database server on a different machine, change the service account for the report server to a credential that is recognized on the database server. Please refer to https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server#creating-a-database-on-a-different-server

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: Restriction on the Report Server Deployment Server node?

josef78 — Mon, 31 May 2021 08:45:00 GMT

Hi,

From technical point of view, yes I agree with v-deddai1-msft , is good practice divide instances to different (virtual) machines, at least, separate SQL Server DB (maybe with SSIS), from SSAS and Power BI RS instances.

From licence point of view, as far as I know, you can NOT install any SQL server product to additional machines and additional (physical) cores. Any MS SQL product part (including SSAS , SSIS, RS) must be licenced. I think, if you have MSSQL EE with SA for 4core, you can install to only one 4core virtual machine for all, or you can install on any number of virtual machines hosted on one 4core physical machine.

But I still recommends, divide your instances, at least to MSSQL DB, and to other instances. Additionally you can combine editions, e.g. you can install MSSQL DB on one machine (where is enough cheaper SQL Standard without SA), and SSAS+Power BI on another machine (where you need EE with SA).