Restriction on the Report Server Deployment Server node?

[mehmet-vrp]

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?  

[v-deddai1-msft · Accepted solution]

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...

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

[josef78 · Accepted solution]

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).

[v-deddai1-msft · Accepted solution]

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...

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