Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts
SQL Server Technical Article
Writer: Carl Rabeler, owner of TheBIGuru.com and mentor at SolidQ
Technical Reviewer: Karan Gulati (CSS), Kay Unkroth (Analysis Services)
Published: August 2012
Applies to: SQL Server 2012; SharePoint 2010; Power View for SharePoint; SQL Server 2012 PowerPivot for SharePoint, SQL Server 2012 Reporting Services for SharePoint
Summary: This document contains step-by-step instructions for installing and testing the Microsoft Business Intelligence infrastructure based on SQL Server 2012 and SharePoint 2010, focused on SQL Server 2012 Reporting Services with Power View. This document describes how to completely install the following scenarios: a standalone instance of SharePoint and Power View with all required components; a new SharePoint farm with the Power View infrastructure; a server with the Power View infrastructure joined to an existing SharePoint farm; installation on a separate computer of client tools; installation of a tabular instance of Analysis Services on a separate instance; and configuration of single sign-on access for double-hop scenarios with and without Kerberos. Scripts are provided for all/most scenarios.