Licensing for a server running SSIS

Question

I am setting up a Business Intelligence environment using SQL Server 2016 and have a licensing question around SSIS.

I have a core database server which will host the datawarehouse, and I understand my licensing options for this.

I have implemented SSIS on a separate server and this is what I need help understanding my licensing options for. This server is a VM, running SQL 2016 Standard Edition. In addition to SSIS, I use the SQL Server RDBMS service on this server to store job and package info plus execution history (all low volume). There is no business data stored on this server. As part of my DB load cycle, I connect to less than 10 other servers. Most of the the server workload is via scheduled jobs running under service accounts. A few individuals (< 10 BI Devs and Dev Ops) connect to the server to monitor activities or release new packages.

Can I use CAL based licensing for this ? If so, am I right to assume I need one Standard Server License plus a CAL for each Service Account and each Individual who would access it ?

Thanks in advance

Answer 1

Hi @Marcus Winn ,

1.***Licensing is always one of the more confusing aspects of any product, and SQL Server 2016 is no exception to that rule.*
Please refer to **An Overview of SQL Server 2016 Licensing.
SQL Server 2016 Editions and Licensing Models
The different SQL Server 2016 editions each have different licensing models. You can see an overview of the editions and their licensing in the following listing.
SQL Server 2016 Enterprise Edition – Core licensing only
SQL Server 2016 Standard Edition – Core or Server + CAL (Client Access License) licensing
SQL Server 2016 Express Edition -- Free
SQL Server 2016 Developer Edition -- Free
SQL Server 2016 Evaluation Edition – 180 day trial

2.***This topic provides details about the features of SQL Server Integration Services (SSIS) supported by the different editions of SQL Server.*
Please refer to **Integration Services features supported by the editions of SQL Server.

Best regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.

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.