How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis 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.

I typically don’t install SQL Server Analysis Services (SSAS), but decided to this time as I was installing all of the Microsoft Dynamics GP additional products for my Hands On with Microsoft Dynamics GP 2016 R2 series.

To install SSAS, launch the SQL Server setup utility and click on Installation and then on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Decide if you want to use Microsoft Update to check for updates (mark the checkbox if you do) and click Next:

SQL Server 2016 Setup: Microsoft Update

Verify the rule checks to ensure nothing failed and click Next:

SQL Server 2016 Setup: Install Rules

Mark the Add features to an existing instance of SQL Server 2016 and click Next:

SQL Server 2016 Setup: Installation Type

Under Instance Features mark Analysis Services and click Next:

SQL Server 2016 Setup: Feature Selection

Enter the Account Name and Password for the Service and click Next:

SQL Server 2016 Setup: Server Configuration

Use the Add button to add users with administrative permissions for Analysis Services.

Once all required users have been added, click Next:

SQL Server 2016 Setup: Analysis Services Configuration

Review the summary and click Install:

SQL Server 2016 Setup: ready to Install

Once installation is complete, click Close:

SQL Server 2016 Setup: Complete

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 *