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

Microsoft Dynamics GPThis 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.

Click to show/hide the How To Install Microsoft SQL Server 2016 Series Index

What should we write about next?

Your Name (required) -
Your Email (required) -

(Visited 226 times, 1 visits today)

Leave a Reply

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