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.
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.
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
Restart is needed
After Reboot – Did the same steps and ended up checking for updates.
Windows Firewall warning is import – We have to disable it as this is a lab environment.
Re-Run the Check to confirm
Choose Database Engine and Analysis Services. You would not find Management Tools any more. Click Next
Choose Named Instance. Better to use for Office Online Server and Excel. Click Next. Here it took a little bit time for me.
Enter Account name and password for Agent, Database Engine and Analysis Services. I am using the same, you can change if needed.
Select Mixed Mode Authentication, Enter password, and choose Add Current User. I am also adding contoso\spadmin as SysAdmin as this is a lab.
Changed the data directores for easy management
Really Liked the new Temp DB View. Click Next
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
Ready to Install
On my machine SQL took around 5 minutes. You think SQL is done but it is not. Let’s Install the management tools.
You should welcome the new Visual Studio look of Management Studio Setup.
This should take 5 to 10 minutes
Reboot is required.
Search and Pin Management Studio and Configuration Manager on the desktop
Right Click on Server Node and Select Properites
Click Advanced and Select Max Degree of Paralleslism to 1 and Clik OK.
Let’s Open Analysis Services
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.
Double Click on the UDL File. Type Server name as Machine\SharePoint.
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.
Next Step – Installing SharePoint Server 2016.