Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
oliflo
Frequent Visitor

Question report server and licensing

Hello

i'm planning to have Power BI Report Server on premise (infra using 3 vm with 4 cores each: 1 for report server, 1 for sql server 2022 and 1 for report catalog), and have some questions:

  1. Do I need 2 seperate licenses for the report server and sql server 2022?
  2. If I'm having Power BI premium capacity license for the report server, does it cover as well sql server 2022?
  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?

Thank you

1 ACCEPTED SOLUTION

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

View solution in original post

4 REPLIES 4
v-binbinyu-msft
Community Support
Community Support

Hi @oliflo ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

d_gosbell
Super User
Super User


@oliflo wrote:
  1. 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:

  1. Is there any other way?
  2. 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-serve... 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors