Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / productivity / SharePoint

Complete Guide to Install SharePoint in a Three Server Farm using AutoSPInstaller

5.00/5 (1 vote)
14 Feb 2019CPOL6 min read 6K  
This is a complete guide to install SharePoint in a three server farm using AutoSPInstaller

Introduction

This article will be divided into three sections:

  • Setting up the Environment and Service Accounts
  • Getting Ready with AutoSPInstaller Online
  • Configuring the XML using Online Editor and Installation

Setting up the Environment and Service Accounts

AutoSPInstaller Online is one great project that facilitates Automated SharePoint installation including Sharepoint 2010, 2013 and 2016.

Auto SP Installer provides a powerful way to deploy and configure a single-server development environment to multiple-server SharePoint farm.
Reference: https://autospinstaller.com/

Before doing anything, we will set up the environment for SharePoint three server Farm.

We will name these servers as:

  • SPWFE - Share Point Front End Server
  • SPAPP - Share Point App server
  • SPDB - DB server

Image 1

Please find the reference for SharePoint minimum requirement and practices from:

For the medium segregation, we have to create the below list of service accounts.

Service Accounts for Active Directory

Service Account name: spadmin
Rights: Local Admin All Servers (DB,WFE,APP)
SQL DB Rights: SQL DB Creator and Security Admin Rights
Domain Privileges: Service User
Description: Use for set up and Configuration

Service Account name: spfarm
Domain Privileges: Service User
Description: sp timer service, Central Admin Application Pool, Other Configurations

Service Account name: spservices
Domain Privileges: Service User
Description: Service and Pool account user

Service Account name: spsqlservice
Domain Privileges: Service User
Description: Run services in SQL Server (MSSQLSERVER, SQLSERVERAGENT)

Service Account name: spsearch
Domain Privileges: Service User
Description: SP search service, crawlers, search related

Service Account name: spprofile
Domain Privileges: Need Replicating Directory Changes
Description: user profile synchronization account

User Profile User Configuration

Run dsa.msc in Run Windows or open Active Directory Users and Computers.

Image 2

Then right click the domain and click delegate control.

Image 3

Then click next and select spprofile user.

Image 4

Then click next and select Custom Task Delegate and click next.

Then select This folder, Existing objects in this folder, and creation of new objects in this folder and click next.

In here, select Replicating Directory Changes and proceed to finish the wizard.

Configure SQL Server

After installing SQL server, you need to do the following configuration. Also, you might need to install .NET 3.5 manually in the server by specifying source path manually.

Setting Up DB Server (Login as spadmin)

I installed Windows Server 2012 in the DB server. After installing OS, you need to install the SQL server. Following are the steps you need to perform additionally.

In the feature selection, you can select Database Services and Management Tools – Basic , Management Tools – Complete. Other than these features, you can select other related ones if needed.

Then you can add spadmin as a Administrator for management.

And you should add spsqlservice as service accounts running credentials for MSSQLSERVER, SQLSERVERAGENT.

Then complete the installation and Enable TCP/IP, and start the SQL browser in SQL configuration management.

Image 5

Image 6

Getting Ready with AutoSPInstaller Online

First, download the latest build from https://autospinstaller.com/Download.

Image 7

and copy, SP folder to C:\ drive (this can be any convenient location):

Image 8

Now, you need to mount your SharePoint Image and copy all the content inside the folder:

2016 –> SharePoint

Then download the prerequisites files as required:

and copy under the prerequisites folder inside SharePoint 2016.

Server Set UP Servers

You need to install the following pre software in Servers in order to Set Up SharePoint.

Application Server Server, Web Front End Server

OS: Windows Server 2016

You might need to install l .NET Framework 3.5 to the server. Thus you need to install manually.

Reference: http://www.danielclasson.com/install-net-framework-35-server-2012/ Jump
http://en.community.dell.com/techcenter/os-applications/w/wiki/4146.installing-net-3-5-framework-on-microsoft-windows-server-2012.aspx Jump

DB Server

OS: Windows Server 2016
SQL Server 2017

After you install the basic required Software and Operating system, now you are ready to install the SharePoint.

Before installing SharePoint, you must configure the AutoSPinstallerInput file.

Image 9

This is just an XML file, you can Edit using NotePad ++, but there is a great online tool provided by AutoSPInstaller Online, that you can use to configure the XML file.

Image 10

You can load the XML and enter your service account details and DB connection details and save the file for installation.

Configuring the XML using Online Editor and Installation

After you have set up everything, as per my previous articles, you need to go to Online Configuration Editor

Image 11

Then, you need to choose Load from my XML and choose the AutoSPInstallerInput file.

Image 12

Then the below page will be visible:

Image 13

We don't need to edit all the configurations for this scenario.

First, add the HOST name for the SharePoint Server. Since we have two SharePoint servers, we will insert two hostnames in both.

If you have a multiple domain environment, use the full domain name for the host.

Image 14

Then, navigate to Install Section and Specify the SharePoint Product Key and the Version to 2016 if it is not selected.

Image 15

then, Navigate to Main section:

Image 16

Here, there are few sections you need to fill up.

First, you need to add the Security Phase for the Farm.

Image 17

Then, we have to mention the farm account name, refer to my first article.

Service Account name: spadmin
Rights: Local Admin All Servers (DB, WFE, APP)
SQL DB Rights: SQL DB Creator and Security Admin Rights
Domain Privileges: Service User
Description: Use for set up and Configuration

Image 18

Since we are not using any custom alias, remove the tick and mention the database server name and the prefix for SharePoint databases.

Image 19

Central Administration will be a provision on the APP server, thus I selected it and remove the SSL because we will be running behind the WAF.

Image 20

Then specify the other accounts which we have created before as below:

Service Account name: spfarm
Domain Privileges: Service User

Service Account name: spservices
Domain Privileges: Service User

Service Account name: spsearch
Domain Privileges: Service User

Service Account name: spprofile
Domain Privileges: Need Replicating Directory Changes

Image 21

Then, navigate to services section and select web application to deploy in WFE server.

Image 22

Then configure the email, setting, You can use the existing Email server.

Image 23

All other sections are optional to configure.

Go to the Review and Download section to copy the configuration file.

Image 24

Copy and paste the XML file to AutoSPInstallerInput file.

Image 25

Now you are done with the configuration.

Just go to Automation Folder:

Image 26

and Launch to install the SharePoint.

Image 27

and do the same installation in SPApp server as well.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)