Forum Discussion
Question report server and licensing
You would normally manage roles for reports/folders throught the web portal. The only reason you would need SSMS is to create custom roles, but this is a very rare occurrance. In most situations the default roles are enough and you can manage these in the web portal itself.
Report Server is either licensed through Power BI Premium or SQL Server Enterprise with SA as per https://learn.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server
oliflo wrote:
- Do I need 2 seperate licenses for the report server and sql server 2022?
You would need to license all 3 VMs so you all 12 cores would need to be licensed
oliflo wrote:2. If I'm having Power BI premium capacity license for the report server, does it cover as well sql server 2022?
No, premium gives you the right to install a SQL instance that is only used for the Report Catalog. If you use that instance for any other purpose then it needs a full SQL license
oliflo wrote:3. If I opt for Enterprise SQL Server license with Software Assurance, does it cover both report server and sql server 2022 together with SSIS and SSAS, irrespective of number of cores?
The SQL Enterprise license does cover Report Server, SSIS and SSAS, but not irrespective of the number of cores. You actually pay for the license based on the number of cores you want to run on.
But also note that you can mix and match the licenses across VMs. So you could buy 4 cores of Enterprise SQL with SA to cover your report server, then buy SQL Standard for the other 2 VMs (if you don't need any of the Enterprise features)
d_gosbell ,Thank you for these clarifications.
In addition, for viewing and managing roles for reports/folders on Power BI report Server, I need to do it through Microsoft SQL Server Management Studio (MSSMS) by connecting to the Reporting Services (setting server type to Reporting Services in the MSSMS). This makes me have 2 more questions:
- Is there any other way?
- Is there a specific license for using Reporting Services or is that same license as the one for SQL Server DB Instance (i.e the premium license used for the Report Catalogue?
Thanks for your help.
You would normally manage roles for reports/folders throught the web portal. The only reason you would need SSMS is to create custom roles, but this is a very rare occurrance. In most situations the default roles are enough and you can manage these in the web portal itself.
Report Server is either licensed through Power BI Premium or SQL Server Enterprise with SA as per https://learn.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server