Notes on Deploying a Highly Available Environment Chris Testa -O’Neill Senior Consultant

1. Notes on Deploying a Highly Available EnvironmentChris Testa-O’NeillSenior Consultant

2. Who am I

3. Agenda BI Infrastructure: The End Game Architecture Preparation Preparing the SharePoint Farm Creating the SharePoint Farm Creating SharePoint Core Services Configuring PowerPivot for SharePoint

4. BI Infrastructure: The End Game

5. BI Infrastructure: The End Game • After you install these features, you will be able to do the following. • Access the PowerPivot workbooks that you created in SharePoint sites. • Build interactive Power View reports based on PowerPivot workbooks in SharePoint. • Create Report Builder reports when you launch Report Builder in SharePoint

6. Architecture Preparation Ingredients Installation Accounts Network Infrastructure Preparation Kerberos Network Load Balancing

7. Ingredients • Windows 2008 R2 Servers SP 1 with .Net 3.5 features enabled (others supported) • SharePoint Software • SharePoint 2010 Enterprise Edition • SharePoint 2010 Service Pack 1 • SharePoint 2010 August 2011 CU • SharePoint 2010 prerequisite files • SQL Server 2012 • Database Engine • Reporting Services and Reporting Services Add-in • PowerPivot for SharePoint

8. Architecture preparation • Installation Accounts

9. Architecture preparation (cont) • Network Infrastructure Preparation • Port discovery of SQL Server data source • Use Configuration Manager • Active Directory Accounts • Create dedicated Service Accounts. • DNS • Register A resource record for Portal site

10. Architecture preparation (cont) • Kerberos • Service Principal Names (SPN) • Exposes objects in Active Directory as a Security Object • Constrained delegation • Enables delegated security permissions on AD Security Objects • Windows 2008 domains provides a GUI. • ADSI Editor required for Windows 2003 domains MSAllowedToDelegateTo

11. Architecture preparation (cont) • Network Load Balancing • Register and A Resource record in DNS (CNAME records causes Kerberos errors) • Configure the NLB to point to the to each of the web front ends • Configure sticky pages on the NLB (1 hour)

12. Demo • Preparing the BI Infrastructure

13. SharePoint Preparation • Creating the database backend • Preparing the SharePoint Farm

14. Creating the database backend • Install SQL Server 2012 in a Failover Cluster • Database Engine Services • Client Tools Connectivity • Management Tools – Complete • Enable TCP/IP for remote connections and restart the service • Enable inbound access for SharePoint to the database server through Windows Firewall.

15. Preparing the SHAREPOINT FARM • SharePoint Product Preparation Tool • Internet connectivity • Unattended Installation • Manual installation • Should be execute on all SharePoint Servers that will be in the farm • Restart the servers

16. Demo • Preparing the SharePoint Farm

17. Creating the SharePoint Farm SharePoint Installation SharePoint Configuration Enabling SharePoint Logging

18. Creating the SharePoint Farm • Installing SharePoint • Install Office SharePoint Server on all Application Servers and Web Front End Servers • Do Notrun the SharePoint Products and Technologies Configuration Wizard. • Install SharePoint SP 1 • Good time to install Office Web Apps on all Servers

19. Creating the SharePoint Farm • Configuring SharePoint • Select a server that will host Central Administration • Run the SharePoint Products and Technologies Configuration Wizard. • Use the Server Farm account to create and access the SharePoint database • PassPhrasecreated during the farm creation. Do not lose this passphrase

20. Enabling Logging on the SharePoint Farm • Enabling logging on the SharePoint Farm • Helps resolve issues during the installation of SharePoint applications. • Use SharePoint setup account to configure • If you change the trace log path to a non-system drive, this location must exist on all the servers in the farm. • usage and health data collection logs selected information into SharePoint Logging • Logging uses system resources and can affect performance and disk usage

21. Demo • Creating and Configuring the SharePoint Farm

22. Creating SharePoint core services Search Service Claims to Windows Token service Excel Services Create a site and site collection Secure Store

23. Creating SharePoint core services • Search Service • Provides search capabilities for content stored in SharePoint • Best practice to install search components on the web front end and application servers • Create a Search Service Application • Move components to the web front end

24. Creating SharePoint core services • Claims to Windows Token Service Place C2WTS in local admins with the additional following rights: Act as part of the operating system Impersonate a Client after Authentication Log on as a service Start the C2WTS on the server that Excel Services is running (usually the APP server) and set the C2WTS to the C2WTS service account In Services, Ensure that Cryptographic Services is listed in the dependencies tab for Claims to Windows Token Service. If there are still issues with the C2WTS then run the following cmd prompt scconfig "c2wts" depend=CryptSvc

25. Creating SharePoint core services • Excel Services • Makes it simple to share Excel workbooks interactively in SharePoint • Relies on the C2WTS to be started if querying remote sources • Add the excel service account as dbo to the WSS_Content database • Register a managed Excel Service Account • Start the Excel Service Application • Create the Excel Service Application • Note Secure Store will need restarting

26. Creating SharePoint core services • Create a site and site collection • Define the Site name and template (BI Center) • Configure Alternate Access Mapping • Create a site collection by using Central Administration –Must use Windows-classic mode authentication for PowerPivot (SharePoint Pros may question this) • Add content sources and configure a search service crawl schedule

27. Creating SharePoint core services • Secure Store • Provides an alternate method of authenrication • Used to store credential securely. • Equivalent to SSRS stored credential • Better off to set it up for authentication flexibility

28. Demo • Configuring the Core Services

29. Configuring PowerPivot • ADD the excel and PowerPivot account to all local admins on the farm and add the following rights Act as part of the operating system • Act as client after authentication • Log on as service • Install ADO.NET Data Services 3.5 SP1 • Run SQL Server Setup to install PowerPivot for SharePoint on Application Server • Just setup one app server first

30. Configuring PowerPivot Configure or repair PowerPivot for SharePoint automates much of the setup Be sure to use a dedicated account Have the SharePoint Farm passphrase available Activate PowerPivot Feature Integration for Site Collections in Central Administration Repeat on the second server

31. Configuring SSRS Install Reporting Services on the application servers. Add Reporting Services Addin on the Web Front End Activate Reporting Services SharePoint Service Integration Create a Reporting Services Service Application

32. Demo • Configuring PowerPivot and SSRS

33. SUMMARY • BI Infrastructure: The End Game • Architecture Preparation • Preparing the SharePoint Farm • Creating the SharePoint Farm • Creating SharePoint Core Services • Configuring PowerPivot for SharePoint • BE PATIENT – Running setup in parallel causes problems

34. Questions • chris@coeo.com • @ctesta_oneill • http://sqlblogcasts.com/blogs/testas/archive/2012/07/31/hi-availability-blog-posts-on-technet-uk.aspx