My findings in Microsoft world

Installing Development Tools SharePoint 2013

This blog is part of Series : Comprehensive SharePoint 2013 Development Environment Installation and Configuration

Overview

This blog article discusses how to install VS.Net 2012 and other development tools necessary.

Development Environment Installation

From the SP2013WFE server login as SPSetup account.

Mount VS.Net 2012 install media (What ever latest you at such as With SP1 is ok too) and run the install.

Install Web Platform to get access to SharePoint 2013 development templates

http://www.microsoft.com/web/downloads/platform.aspx

Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012

Install SQL Server Data tools to get the BI development templates

From <http://www.microsoft.com/en-us/download/confirmation.aspx?id=36843>

Installing Office Web Apps 2013 for SharePoint 2013

This blog is part of Series : Comprehensive SharePoint 2013 Development Environment Installation and Configuration

Overview

This blog article discusses how to install Office Web Apps 2013 on a dedicated server and then integrate with an existing SharePoint 2013 Farm.

Assuming you had already established a SharePoint 2013 Farm and have instantiated a Windows 2012 Server instance dedicated for installing Office Web Apps 2013 Server based on earlier blog.

Reference http://technet.microsoft.com/en-us/library/jj219455.aspx

Steps

Office Web App Server Pre Requisites Installation On Windows 2012

Run below command script to install and pre-requisites.

Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices

Restart the server

Office Web App Server Installation

Mount Office Web Apps 2013 Install on the OWA2013 server and run the Install

Office Web App Server CU Installation

Download and install the Office Web Apps Server 2013 update KB2810007.

From <http://technet.microsoft.com/en-us/library/jj219455.aspx>

Office Web App Server Configuration

Step 1: Create OWA Farm and Configure to use HTTP and Support Editing

Reference http://technet.microsoft.com/en-us/library/jj219455.aspx

From an elevated PowerShell command prompt run below command

Test by accessing from outside your server http://owa2013/hosting/discovery

Office Web App Server Configuration on OWA2013 Server

Step 2: Configure SharePoint 2013 Farm to use the OWA Server

Reference

From an elevated PowerShell command prompt run below command

Now you should see a long list application extension registration with the WOPIZone

To confirm type and test below command to verify that the new zone is internal-http

Change the AllowOAuthOverHttp setting in SharePoint 2013 to True. Run below command

That means we will need to allow SharePoint to allow OAuth over HTTP by running below commands

Now check one more time the status of OAuth over http

Now once again check the WOPI Zone and as you can see it is still se to internal-https

For this installation test since I had used internal and http, I am going to set the WOPI Zone accordingly as below.

Test Office Web Apps with SP 2013

Browse to SharePoint site as user and not as system account (OWA does not work for system account)

Load sample Word Document

Click to open the document in OWA mode.

Installing PowerPivot for SharePoint 2013

This blog is part of Series : Comprehensive SharePoint 2013 Development Environment Installation and Configuration

Overview

This blog article discusses how to install PowerPivot for SharePoint 2013, assuming you have followed prior steps in this series of blogs to establish SQL Server and SharePoint 2013 Farm. This blog is now updated for SQL Server 2012 SP1.

Reference

Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1) (http://technet.microsoft.com/en-us/library/jj218795.aspx)

Install Analysis Services Server in SharePoint Mode for SharePoint 2013 (SQL Server 2012 SP1) (http://technet.microsoft.com/en-us/library/d3310562-82c1-454f-9c48-33a241749238)

Steps

Ensure Excel Service Account access to PowerPivot Analysis Services

From the SQL Server Management tool connect to PowerPivot mode Analysis Services instance>Properties>Security>Add your Excel Services Account

Update Excel Services with PowerPivot Analysis Services

From the Central Administration>Manage Service Applications>Your Excel Service Application>Data Model Settings>Add Server

Here find out the Analysis Services installed in the PowerPivot mode in the step 7.SQL Server 2012 and BI Components Installation and Configuration DC\POWERPIVOT

Verify your Excel Services integration with PowerPivot Analysis Services

If you already have an advanced workbook with slicers or filters, you can upload it to your SharePoint document library and verify you are able to interact with the slicers and filters from the document library view.