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)