Agent Jobs

Installing Sharepoint 2016 on Windows Server 2012 R2 using SQL Server 2014 SP1-CU6 Part 1

How to install Sharepoint 2016 on Windows Server 2012 R2 using SQL Server 2014 SP1-CU6 (Part 1). Part 1 will show everything up to completing the prerequisites installation. Part 2 will pickup at the point of starting the actual Sharepoint 2016 installation. Just a quick note before we begin. If you are upgrading, and just following this along as a reference… Keep in mind that the upgrade path from any versions up to Sharepoint 2010 will need to run through Sharepoint 2013 then on up to Sharepoint 2016. The good news is; this could be a simple hop. You can get the 180 day demo for Sharepoint 2013, move your environment to it, then move it up to Sharepoint 2016 as a final destination. This is the recommended approach from Microsoft.

So lets get started. For starters; this tutorial will be carried out on Windows Server 2012 R2 Standard. Lets get the basics out of the way with a couple screenshots of the Server Environment. First; we are using Windows Server 2012 R2 Standard with SQL Server 2014 SP1-CU6

Windows Server 2012 R2 Standard

SQL Server 2014 SP1-CU6

Also; here’s a quick screen-shot of the SQL Server Database Features which are installed in addition to the traditional Engine services and Management Tools.

Next we’ll address the actual resources you’ll need to carry out the Sharepoint 2016 Installation.

Step 01:

Create two folders. These folders are will contain your Sharepoint 2016 Install file and the Sharepoint 2016 Prequisites. These are the 2 folders I’m creating under my E: Drive.


E:2-SharePointServer2016Prequisites ß Take note of this path. You’ll need it later.

Step 02: Download Sharepoint 2016:

Move this file to your 01-SharePointServer2016 Folder. Do NOT mount or install it yet.

Step 03: Download and Install the Windows Server 2012 R2 Update (KB2919355):

( This may have already been installed by your automatic updates (if you have that setup).

Remember to choose the correct update. Windows8.1-KB2919355-x64 It’s basically the largest file under the download. 690.8MB

Note: By installing KB2919355; you are automatically installing the other updates such as the following:
KB2919355, KB2932046, KB2937592, KB2938439, KB2934018, KB2959977

Once you have the file downloaded; just open it as you would with any .msu update installation. Right-Click, and select ‘Open with’.

Select ‘Keep using Windows Update Standalone Installer’.

Click ‘Open’.

Be patient as the installer completes.

Note: If you’re automatic update for the server is up to scratch; many of these updates will have already been installed including the appropriate .NET. Don’t be surprised if you see the following message:

Step 04: Download the PreRequisites Powershell file Download-SP2016-RTM-Pre-requisites-Files.ps1:
Do not run the .ps1 file just yet at this point.

Step 05: Download and install .NET 4.5.2 ( This may have already been installed by your automatic updates (if you have that setup).

Step 06:

Take note of the Sharepoint 2016 Product Key (Trial Version for 180 days): NQGJR-63HC8-XCRQH-MYVCH-3J3QR

Step 07:

Open Powershell on the server where you are installing Sharepoint 2016. Remember to ‘Run as Administrator’.

You’ll need to set the execution policy to unrestricted/Remotesigned so you can install the prerequisites using the formerly downloaded Powershell file Download-SP2016-RTM-Pre-requisites-Files.ps1.

set-executionpolicy unrestricted -scope currentuser

Set-ExecutionPolicy RemoteSigned

Remember to agree to the prompt and type in ‘y’ for Yes, then press enter, and you’ll see the results below, and do the same for

Step 08:

Run the Powershell file you downloaded at Step 04 Download-SP2016-RTM-Pre-requisites-Files.ps1. Find the file, and right-click ‘Run as Administrator’.

Click ‘Open’.

You’ll automatically be prompted for the folder name where you want to download the prerequisites files. You can get this from Step 01 above which in our case is: E:2-SharePointServer2016Prequisites

Be patient as this process completes.

Once this completes it will simply disappear. Just remember to go to the folder where you’re downloading the prerequisites and ensure they’ve been properly downloaded.

Step 08:

Mount the Sharepoint 2016 installation file. If you recall from Step 01 we put the file in the 01-SharePointServer2016 Folder. Take note of the Drive letter once after it’s mounted. You’ll need to know this for the next step.

In this case it’s Drive F:

Here is the Powershell script you can use to install Sharepoint 2016, including the Prerequisites.

#Directory path where SP 2016 RTM files are kept
$PreRequsInstallerPath= F:

#Directory path where SP 2016 Pre-requisites files are kept
$PreRequsFilesPath = E:2-SharePointServer2016Prequisites

Start-Process $PreRequsInstallerPathPrerequisiteInstaller.exe" -Wait -ArgumentList`
/odbc:`$PreRequsFilesPathmsodbcsql.msi`" `

I’m putting in an extra screenshot of the Powershell text in case the it gets butchered by autocorrect after posting it up to the blog. I want you to see it in it’s original form. By the way; that’s a monokai theme for Powershell. Eat it bitches!

You can use the above script to create the .ps1 file. I simply used notepad, and pasted in the above text, and renamed the file to: Install_Sharepoint_2016.ps1. Keep in mind… After the installation completes it will immediately reboot the server. Technically this is the pre-installation phase so in hindsite I should have perhaps named this PreSharepoint_2016_Installer.ps1.

Once this is run you’ll get the following screen. Just click ‘Next’.

Agree to the terms and click ‘Next’.

Be patient as this process completes.

Click ‘Finish’. Again; keep in mind… After you click Finish it will immediately reboot the server.

The complete text base version of this information can be found at Microsoft Technet Here:


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s