question

MarcusWinn-1063 avatar image
0 Votes"
MarcusWinn-1063 asked Monalv-msft commented

Licensing for a server running SSIS

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

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft commented

Hi @MarcusWinn-1063 ,

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.
83825-integrationservicesupport1.png
83846-integrationservicesupport2.png


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.









integrationservicesupport1.png (39.1 KiB)
integrationservicesupport2.png (20.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image Monalv-msft ·

Hi @MarcusWinn-1063 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·