Install SharePoint Server 2016 on Server 2016 Standard with SQL Server 2014 SP2

Article
1/17/2024

This post is a quick note of step by step when I install a SharePoint 2016 farm for evaluation/development purposes by using “Single server role that uses SQL Server” installation scenario.

Scenario

This evaluation scenario includes a SharePoint 2016 single-server installation (SharePoint 2016 + SQL 2014 SP2 on Windows Server 2016 Standard), basic installation accounts and an existing domain control.

https://lh3.googleusercontent.com/84xZPBaKrHehmi4J1LDWSEcCqBD7zOPKwhYhqi8KKcoRA2I8U1RS85sQt3RmfGuiY3pNojzIGlE5JFDgXS1Dj1uvmmvnxXJFcti7VjwSW04ASOToYBDuKRD1m1Dh4U6jQx3fD8s

Preparation

Make sure you meet the requirement for “Single server role” installation. See Hardware and software requirements for SharePoint Server 2016 at https://technet.microsoft.com/en-us/library/cc262485(v=office.16).aspx. In my case, I use a Hyper-V virtual server with the following configuration.

Installation scenario

RAM

Processor

Hard disk space

Single server role that uses SQL Server

16 GB

64-bit, 4 cores

80 GB for system drive; No need Data drive at installation step

Ensure that you have prepared required accounts with appropriate permissions. For detailed information, see Initial deployment administrative and service accounts in SharePoint Server.

In my case, I use the following accounts.

Account

Purpose

Requirements

sql_service

(SQL Server service account)

The service account for:

MSSQLSERVER
SQLSERVERAGENT

Domain user account (or a Local System account)

The service account isn't needed for a successful SharePoint 2016 installation.

sp_setup

(Setup user account)

The Setup user account is used to run the following:

Setup
SharePoint Products Configuration Wizard

Domain user account.

Member of the Administrators group

SQL Server login

Member of the following SQL Server roles:

securityadmin
dbcreator

sp_farm

(Server farm account or database access account)

Configure and manage the server farm.
Act as the application pool identity for the SharePoint Central Administration website.
Run the Microsoft SharePoint Foundation Workflow Timer Service.

Domain user account.

SQL Server security roles:

dbcreator
securityadmin
db_owner fixed database role for all SharePoint databases in the server farm

sp_service

Use as services account for Service Application and Services

Domain user account

Ensure the Max degree of parallelism is set to 1.For additional information about max degree of parallelism see, Configure the max degree of parallelism Server Configuration Option and Degree of Parallelism

The following is what I set for the SQL Server I plan to install SharePoint Server 2016.

https://lh4.googleusercontent.com/ARVy_6DQXfaHcqgjbzV9Y-fDEvrjKo3p1Mnn92N6NXIM_dLaWiJAyGFBT9CE9VAArHWt_n5M7fRMGcppQCpSC43S1eptbkpcXyGzGZmgami71dmab_v3AckRGOb92i8l5O0jWWk

Installation Sources:
- Microsoft® SQL Server® 2014 Service Pack 2 (SP2): https://www.microsoft.com/en-us/download/details.aspx?id=53168
- SharePoint Server 2016:
- https://www.microsoft.com/en-us/evalcenter/evaluate-sharepoint-server-2016
Lastly, a Virtual Server. In my case, I use Windows Server 2016 Standard version with 16 GB RAM and 80 GB with OS drive. I use minimum values as recommended by Microsoft for Single Server with SQL Server MinRole :)

Installation

Install SQL Server 2014 SP2

Step 1: Add .NET Framework 3.5 Features by running Add Roles and Features Wizard

In order to install SQL Server 2014 SP2 successful, you will need to enable .NET Framework 3.5 Features.

https://lh5.googleusercontent.com/UzMNFkfz0dZUlmgJMV9txW0YL5CO7fKasp4fxwaL9PHDegd0f9miY0a8_HQajS9gQF74GZBz2LP6P96mtn-nHwpPIEcuni-moHyRM0p1eP5E3HrLPvwFfM4jrmZz_qTqe6WFKM0

Step 2: Install SQL Server 2014 SP2 (SQLServer2014SP2-FullSlipstream-x64-ENU.iso)

https://lh3.googleusercontent.com/3BwxMuaobNWoZHQ7ziWsezIgVhExc4h0Qm7t9gWpzKuNPx49LCpQj25JPcyemey7znEsiX7peGuKt062JKs87T5YobzbzRvDEamzFkCBH9o6BG0t29RsPaQKLzcYplHFem-gI5I

https://lh5.googleusercontent.com/04L3cfht_HPam4Xt1JGU5UDLB8qWHDZZqegZR58HKeySEbT0xmmhHWHph2NRHs7QPEpua-5tJEl7nm0yE3nQiXVyiCV9fbToOdKbO18xQ-I-OwSFZsINkFY0kT1Plqozw6WPdhs

https://lh5.googleusercontent.com/zbisY7vK7nWXok6YdAhqhSOdCuFHx2w1jFnwY7McEKJrhfaPzV236kEVIxT5ERl0zg2RBIoKda_QfMZqgx7ECdMrsqHrJLMPiwuiZb6l6hjsbqOJnI7QhM4THyAxtAm5rmPr_iw

https://lh3.googleusercontent.com/aYzHZxVQykcLQ060wMXLD-22qUTZCOLCF_0jooahETTyJc59PhkhNK_uR3fwSBcTG07mjAh8vlNYulpfALk4w1Q7DK-3iDTaUIQ4K8EYEUSr70kvRBHwFxbQJZwFEqkT7MqTlIQ

https://lh5.googleusercontent.com/z_QZscD6AhwGGMCbS2uF2cefka9hipYdO9DZAbm5zrr93hDpX_v8xpUiRulAqLTZiM5dZgwYEfm09upraB2Z_pj1AW6uEUjJHxzbMijrfkgXSgYS1DTJHXiX6vusNveH1_9uW4A

https://lh5.googleusercontent.com/g-U2Mplb9cNpXtlEXvBJLt8MTnStKE_ySR-7u5efpcYKoWltHjkTlnHJOdxrdMp1Y0FkXoKFqiaXCtHy3sI85mqtHNDaNuGJHU7FR611l7qCn7Q2t_62SUQleehX6az4BzW-kjc

You can turn the firewall off during the installation step as optional step. For me, I keep it as it is.

https://lh3.googleusercontent.com/MhWfS0x-sbVaQanJ0ef_KlfwGYO4fUEbgAw7-xQubIrvk0R9HzlQMudpj9zke5In6v0ipgwrm7NywXeDIQXUbYFfnVVM9EsA_D36hj-cYZi-6pFO2iVo1SQMTYTWTwn3_4GMAn0

https://lh4.googleusercontent.com/kYzRbbWChSRq1DtH9c6JXCV-3ReLMapkMCgYjgfEMLM3MdQ7dm_vAEDCAD9lXlADWxuMJcw6btQXCw-wTeBd2JHM_ptSxKlRHCXc6PLaMxDFYZ5w7Pz-dU2U25xDEJn39eCIL8Y

https://lh4.googleusercontent.com/fm0RquBQOSDkb7q5O1bpZnKY-xA6stG1FZfsbBAUgUNXbQvrP-oapjBE7sxSuRy625aGTzzPs_ij_LrhcxmZTDnE0bSNJBbINqM_4t2OQe8ZG6Utg9FSmIip25ry7SGIUIwSz4I

https://lh3.googleusercontent.com/jyrxMzST--Qb0yvOy1FPQ7JVRoMCkqX93l9i3JayvbAG4HlEr8QdtVcSsZiLHa6IYfYARRRpGRw8W8SM8eFN76VYTv-WbqrbfS4Dg-dMJvBmm-InF_uyhBSZXJy19RArg48FWxU

https://lh3.googleusercontent.com/FkOsmDw7fuZ_j8T5KHgEUPXUuz_2e7fzFJztfXmJpyfQAFdr291C6ocjCi8rYPKWxUcVYhUS9rAinuaFDaEPkgqiXlO-OV-buBQwfR9PWLz1eo7CmrbUIqONsLqehxwx3jI2xEs

https://lh5.googleusercontent.com/sLICrTuNgl3aXpipI9ZsR7BVFm3lghSY0HqHeaFxPsAU0Dyx7jXYaRksxc8LGr_y1vPEZYqGa-KIUMJGloKymiEaD-Ml92-i4_Fyblnu9IjOpfAVP2vzSx5In0SVbXO6jxwsoOc

https://lh5.googleusercontent.com/GveJ1t4VfMwXeGfuxp_2zol4a-SqtU-ly-Fs3C7OPKqbyJASODn_uQj0qvg1yqk8GEYSKc44C3vkwkGXhi0TwchzKVB45GM-9ahHHFa7hf5SuQkAke20WpwFvn6ufTyeZRoiZzs

https://lh3.googleusercontent.com/rQDS6uMc2qEjQqG2OuzNXzM1fxROx553eYZucLbhwGTATCTdAgK2sR0Oz9P5RJdR6SY_zgMp_H5ECablHmlXI5jm148lBLVFaVgw_4cN1rp_GvZs7JximXjiC6zFgiBN0bur-A4

https://lh6.googleusercontent.com/Q5U4tx9_qIj85JZN4WEqqEJno2lygYdC0UqM6ovc240L7X61mfxPKS2Tj4CEnLhidloWWbXO3Zv19I-dm3kEWaQTj7asApywp1D802-dUVXAUcL0WeYsOf6FdOjg5aUNScHzY64

https://lh6.googleusercontent.com/aLnA2jd0KyVCz17RYlP00sXJX7va5AOZjmjSAlA_-1cTS6hU7pPT5qm2rCLyLqnNexvB-U1G0vIOm21CWyqB_xXX6SdOug7z9ZUV7QQ_L9pWpBubV_8Dgda8Ejkr4JwvRExS2rE

https://lh3.googleusercontent.com/xTb3KskWNeERJZkY-tagKW-KMcIU-_bbtOfh_AJ00xXa8dncFhPYJPxnZQAWta9v4hDDfo5pu1iHkECy5GOGVj0KUa6weGht4kM4m4wABtYOQyQPHCHO1K7ebtp29DEPKvqJd5s

Step 3 (Optional): Update the SQL Server services to run with the sql_service account. This step isn't needed for a successful SharePoint 2016 installation.

https://lh4.googleusercontent.com/YGwk8nXYsTyyD9zcee5XKTeksS-QX8CnEdQ64cEJ8sHFn5xtCtoWRTdCHGX_UXGFbLsrFyQ3jKa2AU9AUl741KeRXrNaJQhGHRbNY_e0OJ3KPZAcA2KwtBvMnHFmNDrOS_QrLww

Step 4: Configuring permission for the SharePoint accounts: sp_farm and sp_setup

Following the description from preparation step, the sp_farm and sp_setup need to be configured with appropriate permission in SQL Server. See the following pictures for details.

https://lh3.googleusercontent.com/oJNPWwGZvmDPel01vJ6aMsj6jY0YNTupr7NEIXO9VAMNG0aAyJqO9-R2_x9AqP2z1bbHCxcQQQM1G4XHfHDOmI1GfYyxYbr1t8muV6qYUjmeoUgwvEsRJNKNxCcOJ2CzXl8AdKo

If the sp_farm account has not created in SQL Server, we can add it from here and then configure its permissions as needed.

https://lh5.googleusercontent.com/O4dkM69vvfAKJfg4O9zfJ_FqVo7HdeNSCRJvfKTLhbZ1RJsRzmqpU0d3wilO1w_o7jV62s-MdvBdSBQRKMgrKunNGZwT7pX6badQsZ5TDuj1dL5pwwMHqGKJY2oNFDmQlqTJ0zk

https://lh3.googleusercontent.com/WXR98IZeBoipk7rXLEa1wHSD8nfYAos_x1twyKxQKwzqSCNu7vfgYzy1MavfZ-XuN_P_E40ZXXtc4vRJrhqlJ8U1QZ2VcKLUBjZxyIVt1y_9pAwVBBh72thN0hjtRh9cXLdFu4M

https://lh6.googleusercontent.com/wlZqYD4Vj8XtTp_LWG9FV3K1WFd3jVGMXc8nNHK0zUYoyBJrLKWwiVMfDLHXHOXLmKzw4piEt5vKAZNGhVWMv3qGESGhdUAJ-Cp17Qjm3F1PwMmIxkiDBoqGB30ZnWgOdoT8vfs

Install SharePoint Server 2016

Step 1: Turn off the IE Enhanced Security Configuration

This step I use the internet connection to install the prerequisite. Hence, the server has to be able to download and install from the internet. The following picture demonstrates how I turn it the IE Enhanced Security Configuration off
From Server Manager windows, Click on Local Server on the left navigation ⇒ Click on the On link next to IE Enhanced Security Configuration to turn it off

https://lh5.googleusercontent.com/J6H497RDJWepKd80MtRMVkcFU6Iezllne-_GVIhzBcCRUwBxAWlbc_CwuvBI28s4g24miOiZxSKzdQ4NJPeCnNaNM3aRIzDMlIufUc8KvE-Ji8SN1LRpnpDVzZIouUAP6L0uBFE

Step 2: Run “Microsoft SharePoint 2016 Products Preparation Tool”

https://lh4.googleusercontent.com/mRtWVwG_AQb4-JpCWlxXNPyls1F5ZICh3KL2guBRsKVAfJXdM8JcZK50aj8azCx5Y9B-SW0CkH4BZrb-YmvoIloiPk5SXVhSC6qOFpvKa4Q1MTMncajDXZghlNSz9hgJhJMbiRA

https://lh6.googleusercontent.com/8I4B8yTcmfSQ71tmF9iAoDenvhBeN0N-nWUPKX6-kxtitqAcb2OkRrf8g58SPI73Ytf5_IrUA2PVaarRRxtiuRrn7x10jqeoZcG_vmqQlGp3Ur4Uh3fPKjJwrmXyzQ5xkH_bW3c

After restarting the server, if the prerequisite doesn't start automatically, you can start it manually by using the following command
Start “Launch SharePoint preparation tool” “E:\prerequisiteinstaller.exe” /continue

https://lh3.googleusercontent.com/RY0IdsBmnPsBkgMPSb9zugGg8LiumlfAg5h06sZdsB463-QM5PLQpRUxMqCH30xiltjI9wh6PW0pOT7Vz66fc7kXmezijk-EEeYvtt8Sq-g2OK_Ij7tf4O2PlrJrRnY4FoGEPdw