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.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

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