Scripted Installation of SharePoint 2013 and Office Web Apps Server – From the Field (Part 2)

This is the second post in the Scripted Installation of SharePoint 2013 and Office Web Apps Server series. If you have not already done so, please see part one of this blog series: Farm Topology and Prerequisites.

1. Farm Topology and Prerequisites
2. SharePoint Installation, Configuration and Basic Service Applications Deployment
3. User Profile, Search and Distributed Cache Service Applications Deployment
4. Office Web Apps Server farm Implementation and Configuration

This blog post will cover:

• Installation of SharePoint 2013
• Farm creation and configuration
• Implementation of:
• Excel Services
• Secure Store
• Usage and Health Data Collection
• Managed Metadata Services
• State Services
• Configuration of services on servers
• Configuration of usage and health data collection
• Configuration of state service
• Configuration of diagnostic logging

Servers in Farm

The following table illustrates the server names and associated server roles for each server:

Server Name	Server Role
SPWEB01	SharePoint 2013 Web Server 1
SPWEB02	SharePoint 2013 Web Server 2
SPDCache01	SharePoint 2013 Distribution Cache Server 1
SPDCache02	SharePoint 2013 Distribution Cache Server 2
SPAPP01	SharePoint 2013 Application Server 1 (CA)
SPAPP02	SharePoint 2013 Application Server 2 (CA)
SPQuery01	SharePoint 2013 Query Processing and Index Server 1
SPQuery02	SharePoint 2013 Query Processing and Index Server 2
SPCrawl01	SharePoint 2013 Admin, Crawl, Content Processing, Analytics Processing Server 1
SPCrawl02	SharePoint 2013 Admin, Crawl, Content Processing, Analytics Processing Server 2

Installation Prerequisites and Assumptions

• Please download and extract attached files onto local directory. It has been assumed that this directory is local folder on all SharePoint serves created as E:\Scripts\Install
• It is assumed that the SharePoint installation directory is D:\
• Update the SilentConfig.xml file with SharePoint product key. Please see Config.xml reference on TechNet for more information.
• Update the Config.xml file with environment specific information such as, SQL server alias name (To improve ease of maintenance, and make it easier to relocate the database if it is required in the future, create DNS aliases that point to the IP address for all instances of SQL Server), farm account details, admin database and configuration database.  
• Update the SPCredentials.xml file with service accounts and passwords information.
• Update the SPServices.xml file with Usage and Health data collection log file location, Usage and Health data collection maximum file size, SQL server name, service application names and related database names.

Install SharePoint

1. Microsoft SQL Server 2008 R2 Native Client is installed as part of SharePoint 2013 prerequisites installer, however if you are using SQL Server 2012 to host SharePoint databases, Install Microsoft SQL Server 2012 Native Client 64-bit edition on all SharePoint servers.
2. Install SharePoint prerequisites and SharePoint binaries by executing the following script on all servers listed above (launch SharePoint Management Shell as administrator): 

Set-ExecutionPolicy Unrestricted –force 
E:\Scripts\Install\SPInstaller.ps1 -installPath D:\ -offline "n"
Import-PSSession $session

Please note: Windows PowerShell execution policies let you determine the conditions under which Windows PowerShell loads configuration files and runs scripts. The execution policy is not a security system that restricts user actions. Instead, the execution policy helps users to set basic rules and prevents them from violating them unintentionally. Please see About Execution Policy TechNet article.

This script will automatically restart servers as required. Do not run configuration wizard until installation is completed on all servers
The following steps are performed on individual servers specified in each step:

Create the Farm

Login to SPAPP01 (Application Server hosting the Central Administration site) using the installer account and launch SharePoint Management Shell as administrator. Execute the following command to create the farm:

E:\Scripts\Install\SPConfig.ps1 -configLocation E:\Scripts\Install\Config.xml -createJoin create -isCA "y"

Join Servers to the Farm

Login to SPAPP02 (The second Application Server hosting the Central Administration site) and launch SharePoint Management Shell as administrator. Execute the following PowerShell script:

E:\Scripts\Install\SPConfig.ps1 -configLocation E:\Scripts\Install\Config.xml -createJoin join -isCA "y"

Run the following script on the below SharePoint servers:

E:\Scripts\Install\SPConfig.ps1 -configLocation E:\Scripts\Install\Config.xml -createJoin join -isCA "n"

Server Name	Server Role
SPWEB01	SharePoint 2013 Web Server 1
SPWEB02	SharePoint 2013 Web Server 2
SPDCache01	SharePoint 2013 Distribution Cache Server 1
SPDCache02	SharePoint 2013 Distribution Cache Server 2
SPQuery01	SharePoint 2013 Query Processing and Index Server 1
SPQuery02	SharePoint 2013 Query Processing and Index Server 2
SPCrawl01	SharePoint 2013 Admin, Crawl, Content Processing, Analytics Processing Server 1
SPCrawl02	SharePoint 2013 Admin, Crawl, Content Processing, Analytics Processing Server 2

 Register Managed Accounts

Login to SPAPP01 (Application Server hosting the Central Administration site) using the installer account and launch SharePoint Management Shell as administrator. Execute the following command to register managed accounts in the farm:

E:\Scripts\Install\SPCredentials.ps1 -configLocation E:\Scripts\Install\SPCredentials.xml

Configure Basic Services

Login to SPAPP01 (Application Server hosting the Central Administration site) using the installer account and launch SharePoint Management Shell as administrator. Execute the following command to start required services and stop unwanted ones:

E:\Scripts\Install\SPServices.ps1 -configLocation E:\Scripts\Install\SPServices.xml

 The above script will stop unnecessary services from servers and starts the following service:

• Excel Services
• Secure Store
• Usage and Health Data Collection
• Managed Metadata Services
• State Services

Configure Usage and Health Data Collection

Login to SPAPP01 (Application Server hosting the Central Administration site) using the installer account and launch SharePoint Management Shell as administrator. Execute the following command to start and configure Usage Service:

E:\Scripts\Install\SPUsage.ps1 -configLocation E:\Scripts\Install\SPServices.xml

Configure State Service

Login to SPAPP01 (Application Server hosting the Central Administration site) using the installer account and launch SharePoint Management Shell as administrator. Execute the following command to start and configure Usage Service:

E:\Scripts\Install\SPStateService.ps1 -configLocation E:\Scripts\Install\SPServices.xml

You should now have basic services started on all servers in the farm. It is recommended to check Servers in Farm page from Central administrations site to ensure that the correct services are started.
By the end of this blog series the expected farm topology will be as illustrated below:

Server Name	Server Role	Services
SPWEB01	Web Server	Microsoft SharePoint Foundation Web Application  Microsoft SharePoint Foundation Workflow Timer Service  Managed Metadata Web Service
SPWEB02	Web Server	Microsoft SharePoint Foundation Web Application  Microsoft SharePoint Foundation Workflow Timer Service  Managed Metadata Web Service
SPDCache01	Distribution Cache	Distributed Cache  Microsoft SharePoint Foundation Workflow Timer Service  Microsoft SharePoint Foundation Web Application
SPDCache02	Distribution Cache	Distributed Cache  Microsoft SharePoint Foundation Workflow Timer Service  Microsoft SharePoint Foundation Web Application
SPAPP01	Application Server	Central Administration  Excel Calculation Services  Microsoft SharePoint Foundation Workflow Timer Service  Secure Store Service  User Profile Service  User Profile Synchronization Service
SPAPP02	Application Server	Central Administration  Excel Calculation Services  Microsoft SharePoint Foundation Workflow Timer Service  Secure Store Service  User Profile Service
SPQuery01	Search - Query Processing and Index	Microsoft SharePoint Foundation Workflow Timer Service  Search Host Controller Service  Search Query and Site Settings Service  SharePoint Server Search
SPQuery02	Search - Query Processing and Index	Microsoft SharePoint Foundation Workflow Timer Service  Search Host Controller Service  Search Query and Site Settings Service  SharePoint Server Search
SPCrawl01	Search - Admin, Crawl, Content Processing, Analytics Processing	Microsoft SharePoint Foundation Workflow Timer Service  Search Host Controller Service  Search Query and Site Settings Service  SharePoint Server Search
SPCrawl02	Search - Admin, Crawl, Content Processing, Analytics Processing	Microsoft SharePoint Foundation Workflow Timer Service  Search Host Controller Service  Search Query and Site Settings Service  SharePoint Server Search

Lookout for the next blog post, where we complete the farm configuration by provisioning search, user profile services and distributed cache service.