Share via

Install only SQL SERVER 2022 integration services on host

Alen Cappelletti 951 Reputation points
2024-05-08T10:36:48.9+00:00

Hi,

during the SQL SERVER 2022 installation process, I selected only the Integration Services and the master-out.
With my surprise the process not required installation of the SQL SERVER engine.
At the end, as I suspected, it also installed a SQL instance.

User's image

This passage is not clear to me. Why the process didn't force me to install SQL engine, if it created it anyway?

I was wondering how I could create the "sissdb" to support them in project deployment mode... naturally needs a DB/Instance

What are the benefits of this type of installation... without selecting the engine if the sql service then installs it anyway?

Is an engine still mandatory? The ssis could all be on file systems... but without scheduling (SQL SERVER AGENT) it would be difficult.

ALEN

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,853 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,006 Reputation points
    2024-05-08T11:38:38.5833333+00:00

    SSIS is a "shared service", mean's per machine you can have SSIS only once in one version and that one can run as stand-alone service. The SSISDB can be hosted anywhere else

    You can install the database engine up to 50 times as "named instance" per machine and this in different versions & editions.

    See

    https://learn.microsoft.com/en-us/sql/sql-server/install/work-with-multiple-versions-and-instances-of-sql-server?view=sql-server-ver16

  2. Erland Sommarskog 102.2K Reputation points MVP
    2024-05-08T21:33:41.32+00:00

    If you have the Database Engine installed, I think it is because you selected it during install. Or it was there already.

    I made the selection you did: Integration Services + Scale Out Master. This is what I see in SSCM:

    User's image

    This is what I see in the Services applet:

    User's image

  3. ZoeHui-MSFT 33,386 Reputation points
    2024-05-09T01:39:01.2366667+00:00

    Hi @Alen Cappelletti,

    Starting in SQL Server 2012 (11.x), Integration Services stores objects, settings, and operational data in the SSISDB database for projects that you've deployed to the Integration Services server using the project deployment model. The Integration Services server, which is an instance of the SQL Server Database Engine, hosts the database. For more information about the database, see SSIS Catalog. For more information about deploying projects to the Integration Services server, see Deploy Integration Services (SSIS) Projects and Packages.

    Regards，

    Zoe Hui

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

  4. Alen Cappelletti 951 Reputation points
    2024-05-09T07:24:54.03+00:00

    I found the correct answer: https://learn.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver16&source=recommendations#install-a-dedicated-server-for-etl-processes

    Install a dedicated server for ETL processes

    To use a dedicated server for extraction, transformation, and loading (ETL) processes, install a local instance of the SQL Server Database Engine when you install Integration Services. Integration Services typically stores packages in an instance of the Database Engine and relies on SQL Server Agent for scheduling those packages.

    If the ETL server doesn't have an instance of the Database Engine, you have to schedule or run packages from a server that does have an instance of the Database Engine. As a result, the packages aren't running on the ETL server, but instead on the server from which they're started. As a result, the resources of the dedicated ETL server aren't being used as intended. Furthermore, the resources of other servers may be strained by the running ETL processes.

    From my point of view it makes no sense to dedicate an instance to integration services without having the possibility of scheduling on it. So it always makes sense to also install the engine... (which the license includes) and limit the use of maximum memory with a CAP.

    ALEN

    0 comments