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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

License SQL

Hi guys

i understand the license of SQL Server ent core with an EA can be used to install Power BI Report Server. 
but my question is

 1) can you use the same key on a spearate install on a different server

2) if not, can you install it on a current sql ent seever with other database already install or does it need to be separate and a fresh install. 


thank you as I can find that part of the documentation anywhere. 

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@Anonymous wrote:

 1) can you use the same key on a spearate install on a different server

 


You can use the same key, but it depends on how many cores you purchased and how many are used. So if you purchased 8 cores of SQL Enterprise with Software Assurance and only install SQL Server on a machine with 4 cores. Then you could install the remaining 4 cores of that license on another machine and install PBIRS on that. If however you are using all of the cores for your current license you would either have to install PBIRS on the same server as SQL Server or you would need to buy additional licenses (or reduce the number of cores on your SQL Server)

 


@Anonymous wrote:

2) if not, can you install it on a current sql ent seever with other database already install or does it need to be separate and a fresh install. 


PBIRS is basically a web application and it is a separate install from SQL Server. So you could install onto your existing server and then configure it to use the existing SQL instance for its databases.

 

Note that if you install both PBIRS and SQL on the same machine you will need to make sure that the resources on that machine are sufficient to run both applications. And you should configure the memory limits on SQL so that it leaves some memory for PBIRS (by default SQL Server will attempt to use as much memory as it can)

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

They are saying I need to buy a new sql ent licence and can't use the same sql server where we have already purchased SQL Ent core on an EA


@Anonymous wrote:

They are saying I need to buy a new sql ent licence and can't use the same sql server where we have already purchased SQL Ent core on an EA


So from a licensing perspective I do not believe this is not correct. The SQL license allows you to run any of the SQL product family - the database engine. SSAS, SSIS, MDS, DQS or PBIRS on those cores.

 

But if the existing server is already heavily loaded and does not have the capacity in terms of available RAM and CPU then from a resourcing perspective then it is probably not possible to use the same server. And Ideally it is better not to mix workloads on the one server if you can, but for small departmental solutions you can sometimes get away with it. 

d_gosbell
Super User
Super User


@Anonymous wrote:

 1) can you use the same key on a spearate install on a different server

 


You can use the same key, but it depends on how many cores you purchased and how many are used. So if you purchased 8 cores of SQL Enterprise with Software Assurance and only install SQL Server on a machine with 4 cores. Then you could install the remaining 4 cores of that license on another machine and install PBIRS on that. If however you are using all of the cores for your current license you would either have to install PBIRS on the same server as SQL Server or you would need to buy additional licenses (or reduce the number of cores on your SQL Server)

 


@Anonymous wrote:

2) if not, can you install it on a current sql ent seever with other database already install or does it need to be separate and a fresh install. 


PBIRS is basically a web application and it is a separate install from SQL Server. So you could install onto your existing server and then configure it to use the existing SQL instance for its databases.

 

Note that if you install both PBIRS and SQL on the same machine you will need to make sure that the resources on that machine are sufficient to run both applications. And you should configure the memory limits on SQL so that it leaves some memory for PBIRS (by default SQL Server will attempt to use as much memory as it can)

Anonymous
Not applicable

Thank you for this @d_gosbell 

Cann you please provide links that state this can be done. This is my understanding, but my support is stating otherwise and it needs to be on a dedicated sql server


@Anonymous wrote:

Thank you for this @d_gosbell 

Cann you please provide links that state this can be done. This is my understanding, but my support is stating otherwise and it needs to be on a dedicated sql server


There are links here to documents on both ways of licensing Power BI Report Server https://docs.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server. Last time I looked at the volume licensing stuff they were huge word documents covering lots of products and you had to search through them to find the sections specific to PBIRS.

 

What specifically are your support staff saying?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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