How To verify Microsoft Integration Services is installed on SQL Server
SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server. The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on (please see the example below):
Verification methods
Method 1: Using SQL Server Configuration Manager (SSCM)
To verify if SSIS is installed on the SQL Server, you can use a tool called SQL Server Configuration Manager (SSCM). SSCM is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers.
Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager does not appear as an application in newer versions of Windows.
Follow these steps to open SQL Server Configuration Manager:
- To open the SQL Server Configuration Manager, go to the Start Page or Search box (see Figure 01).
- Type the SQLServerManager<version>.msc such as SQLServerManager14.msc for SQL Server 2017, and then press the Enter Key.
- When the SQL Server Configuration Manager appears, Click on the SQL Server Services in the left panel (see Figure 02).
Note: if SQL Server Integration Services is installed and running, it will appear in the right panel (see Figure 03).
Figure 01
Figure 02
Figure 03
Method 2: Using SQL Server Installation Center
To check if SSIS is installed, head to the SQL Server Installation Center, click on the Tools tab, and run the Installed SQL Server features discovery report. This opens a browser page where you can quickly see if Integration Services is listed under your features. If it’s missing, just run your SQL Server setup again, select the "Add features to an existing installation" option, and check the box for Integration Services to get it installed. Please see the example below (Integration Services in the red rectangle):
Book a Success Call
Need Help?
Evaluating COZYROC? --> Success Call
Customers --> Submit a Ticket
Related Articles
How to check the version installed for SQL Server, Visual Studio, SSDT/SSIS Projects, and COZYROC SSIS+
Verifying the COZYROC SSIS+ Release The existing release of the COZYROC SSIS+ Suite can easily be identified through the License Application, which is installed during setup. The License Application is used to retrieve and/or remove the license key. ...Error Message: Found no compatible SSIS framework. Installation aborted
Action: When trying to install the COZYROC SSIS+, I received the following error message: Error Message: “Found no compatible SSIS framework. Installation aborted”. Solution: This error message indicates that you do not have properly installed SQL ...Installation and Getting Started
Overview This article contains information to help ensure proper installation and configuration of your environment, but most importantly, ensure that COZYROC SSIS+ Suite will work with the installed components (e.g., SQL Server, SSDT). Although SSDT ...How to upgrade an existing COZYROC SSIS+ Suite installation to a higher version.
Before upgrading your existing COZYROC SSIS+ Suite to a higher version, we recommend that you first review this entire page in detail. Depending on your upgrade situation you may need to reference the Compatibility Charts on the Installation and ...Is it required to install SSDT on the SQL Server?
SQL Server Development Tools (SSDT) will always need to be installed on the machine(s) where you design your packages. It allows you to design and deploy SSIS packages using Visual Studio. For SSIS+ releases prior to 2.0: If you are using Data Flow ...