The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
Solved! Go to Solution.
@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)
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.
@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)
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?