Creating a SQL Server 2012 playground (part VI)

Introduction

In this blogpost I'll describe the installation of SSAS for powerpivot for Sharepoint.  Installation of Powerpivot provides the ability to view and store workbooks in sharepoint 2010.


This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Installation of SSAS for powerpivot for Sharepoint

In one of my earlier blogposts (part V) I've already described the installation of the Tabular mode and  these steps taken are almost equal to the installationsteps of the SQL Server Powerpivot for Sharepoint. Therefore I'll not show all the windows but only a selection of the most important windows.

So startup the setup of the SQL Server 2012 installation and choose for a new installation, run the setup support rules and press a couple of times on Next and you'll see the following window. There is an option on the Setup Role screen to add a SQL Server database engine to the installation. Since we already have a brand new instance of SQL Server Relational Engine installed earlier, I unselect this option. Press Next...

The following window appear

If you don't have Sharepoint Enterprise installed you'll get an error.

A more detailed message

When you have installed the Sharepoint Enterprise version you're allowed to pass and install the Powerpivot instance. Successful!

Conclusion

Important to notice is the inevitable Enterprise edition of Sharepoint 2010 (and not standard).  Generally speaken, the installation is smooth and easy.

Hennie