How To Install Microsoft SQL Server 2016: Installing SQL Server Integration Services

Microsoft SQL ServerThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

When I started the installation of the Analysis Cubes for Microsoft Dynamics GP as part of my Hands On with GP 2016 R2 series, I knew I needed SQL Server Analysis Services (clue was in the name), but I didn’t initially realise that I was going to need SQL Server Integration Services (SSIS) although in retrospect it should have been obvious too.

The reason SSIS is needed, is that the Analysis Cubes in SSAS are populated by integration jobs from SSIS (scheduled using SQL Server Agent).

So I had to come back and install SSIS. You do this by launching the SQL Server setup utility and, under Installation click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Decide if you want updates from Microsoft Update and then click Next:

SQL Server 2016 Setup: Microsoft Update

Verify that all rules have not failed and click Next:

SQL Server 2016 Setup: Install Rules

As we are installing SSIS on the same server as the rest of SQL, mark the Add features to an existing instance of SQL Server 2016 and click Next:

SQL Server 2016 Setup: Installation Type

Under Shared Features mark Integration Services and click Next:

SQL Server 2016 Setup: Feature Selection

When configuring the Service Account it wasn’t very keen on allowing me to use a domain account, so I left the default account in place and just clicked Next:

SQL Server 2016 Setup: Server Configuration

Check the summary of the installation options and click Install:

SQL Server 2016 Setup:

Just before the end of the installation, I received a message stating that One or more affected files have operations pending. You must restart your computer after the setup process is completed. I’m not sure if this message always appears when installing SSIS, but if it does then click OK and remember to restart your computer when the installation is complete:

One or more affected files have operations pending. You must restart your computer after the setup process is completed.

Once the installation is complete, click Close:

SQL Server 2016 Setup: Complete

Before using SSIS, reboot your machine if you received a message prompting for this.

Can ISC Software help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you would like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name

Your Email


Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

Your email address will not be published. Required fields are marked *