Installing SharePoint Server 2016

SharePoint Server 2016 is RTM so its time to go back to the installation of latest software.  I am using SQL Server 2016 RC0 and Windows Server 2012 R2.  The goal is to complete installation for single Server SharePoint with Business intelligence.

3 Server Farm Setup

In this step I have

Active Directory VM : 700 MB RAM 2 Cores

SQL Server  VM: Dynamic Memory : 4 GB to 8 GB and 4 Cores

SharePoint Server VM: Dynamic Memory 8 GB to 12 GB and 6 Cores

All of this setup is on Windows 10 HyperV.  I am running it all on SSD so performance is pretty good.

I have Windows Server 2012 R2 with all latest updates installed.  I have basic service accounts already setup.

  • SPFArm
  • SPServices
  • SPWebApps
  • SPSearchService
  • SPContentAccess
  • SQLAdmin
  • SQLService

Installing SQL Server 2016 Release Candidate 0

I downloaded the RC 0 from MSDN and below are steps to install it.  I Mounted the ISO to My VM Media.

image

image 

image

Here you will notice a nice change.  You can either install SQL Server, Management Tools or Data Tools.  I choose New SQL Server stand-alone Installation

image

Choose Evaluation

image

image

Restart is needed

image

After Reboot – Did the same steps and ended up checking for updates.

image

image

image

Windows Firewall warning is import – We have to disable it as this is a lab environment.

image

image

image

image 

Re-Run the Check to confirm

image

Choose Database Engine and Analysis Services.  You would not find Management Tools any more. Click Next

image

Choose Named Instance.  Better to use for Office Online Server and Excel.  Click Next.  Here it took a little bit time for me.

image

Enter Account name and password for Agent, Database Engine and Analysis Services.  I am using the same, you can change if needed.

image

Select Mixed Mode Authentication, Enter password, and choose Add Current User.  I am also adding contoso\spadmin as SysAdmin as this is a lab.

image

Changed the data directores for easy management

image

Really Liked the new Temp DB View.  Click Next

image 

Choose PowerPivot Mode.

Click Add Current User, Now add SPFarm, SPAdmin, SPWebApp, SPServices account here for Office Online Server.

I did not changed the Data Directories for Analysis Services

image

Ready to Install

image

Updates

image

image

On my machine SQL took around 5 minutes.  You think SQL is done but it is not.  Let’s Install the management tools. 

image

You should welcome the new Visual Studio look of Management Studio Setup.

image

image

This should take 5 to 10 minutes

image

Reboot is required.

image

Search and Pin Management Studio and Configuration Manager on the desktop

image

image

image

Right Click on Server Node and Select Properites

image

Click Advanced and Select Max Degree of Paralleslism to 1 and Clik OK.

image

Let’s Open Analysis Services

image image

image

Test the Connectivity with SQL Server from SharePoint Box.

Login to SharePoint VM or Server as SPAdmin or SPSetup Account.

Create a New Text File on the Desktop and Save it as Test.UDL.  Make sure you choose All files.

image

Double Click on the UDL File.  Type Server name as Machine\SharePoint.

image

If you can see the 4 Out of the Box SQL Databases you can all good for SQL Now.  You can click Test connection after selecting a database.

image

Next Step – Installing SharePoint Server 2016.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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