SQL Server reporting server license.

Question

Hi all ,

I wanted to know, we have sql sever 2017 enterprise license. If I will install SQL server reporting server and sql server in two different server then how many EA licenses will consume. Will it treat per server or considered as one utilization.

Answer 1

With one SQL Server license you are allowed to install all components on one machine, not more.

This is a community forum for technical questions & issues.

For question regarding pricing / licensing please contact a Microsoft sales partner or licensing expert.

Call (1-800-426-9400), Monday through Friday, 6:00 AM to 6:00 PM PST to speak directly to Microsoft licensing specialist.

Answer 2

Hi @AlexRobert ,

SSRS can be used with SQL Server Standard Edition. It does not need a special licence/SA or Enterprise Edition.

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi @AlexRobert ,
Enterprise Edition is ideal for applications requiring mission critical in-memory performance, security and high availability.

We know that the Enterprise Edition uses core-based licensing.

This license allows for an unlimited number of users and devices to be connected to a server. If you want to install your SQL servers under a Core Based License, make sure you can follow these rules:

• You need to license every physical operating system environment (OSE) that is running SQL server software. You will need a core license for every core in the processor.
• You need at least four core licenses for each physical processor on the server (core licenses are sold in packs of two).
• The SQL Server or any of its components needs to be licensed. What this means is that you can't separate products of the SQL server over different machines. If the SQL Server Agent is running exclusively on one SQL server and the SQL server reporting services is being run exclusively on another machine, you'll run into problems if you try to license that all under a single license. You would need two separate licenses for that scenario.
• Anything that is installed on the physical machine you need to have a license for. You don’t necessarily need it to be running to require a license for it.
• The same logic is applied when using virtual cores in virtual environments.

A math problem: Let's say I have a single physical server. On the physical server, there are two processors, each with six physical cores with a total of twelve cores. In addition to the license for the operating system, I would need 6 core licenses (since they come in packs of two) in order to be properly licensed.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.