Share via

SQL SSIS on Separate Server

ovsp 166 Reputation points
2024-05-06T02:30:31.79+00:00

Hi,

I'd like to confirm if we need a another SQL license for the server where SSIS will be installed aside from the primary SQL Server?

Thank you,

Jovsp

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,851 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 33,386 Reputation points
    2024-05-06T02:51:28.01+00:00

    Hi @ovsp，

    To install SSIS, you need a SQL Server license. Depending on the tasks you want to do with SSIS, you either need Enterprise or Standard licensing. In most scenarios, Standard should be sufficient. It also means you need a SQL Server license for every machine you install SSIS on. If you install SSIS on the same machine as the database engine, SSIS "comes free" with the SQL Server license.

    Regards，

    Zoe Hui

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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest