How to Install SharePoint 2013 with SQL Server 2014 on Server 2012 R2
=======================================================================

1. Create Domain User Accounts for the installation and grant local admin permissions to the install accounts.

- SQL_Install	(Local Admin)
- SQL_Service
- SP_Install	(Local Admin)
- SP_Service
- SP_Farm

2. Plan and prepare the disks for the SQL 2014 installation

- Dedicate separate disks for DB and Log files
- TempDB and TempDB Logs should use the fastest disks or fixed size Virtual Disks
- Format the SQL DB and Logs disks with 64KB NTFS allocation unit size (instead of the default 4KB)

# You can check the current Allocation Unit size for a specific drive (ex. drive D:) with:
CHKDSK D:


3. Add .Net Framework 3.5 SP1 feature.

- If there is Internet connection, ignore the warning for the source files - they will be downloaded automatically (~230MB)
- If there is not Internet connectivity or there is Proxy server in place, specify manually the installation files from the Server 2012 R2 disk 

#For example, if the Server 2012 R2 disk is drive "D:"
dism /online /enable-feature /featurename:NetFX3 /all /Source:D:\sources\sxs /LimitAccess  

4. Donwload the latest SQL 2014 Cumulative Update and slipstream it into SQL installation files:

# SQL Server 2014 cumulative update (CU) builds
http://support.microsoft.com/kb/2936603

5. Install SQL Server 2014

# Open Command Prompt as admin and run SQL setup with the "/Action" and "/UpdateSource" switches 

setup.exe /Action=Install /UpdateSource=.\Updates

6. Configure protocolos and firewall rules for SQL Server 2014/SharePoint 2013

6.1 Enable TCP/IP

6.2 Configure the Windows Firewall- allow inbound port 1433

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN


7. Optimize SQL Server 2014 for SharePoint 2013

7.1 Open SQL Server Management Studio and check the build number - you should see the build of the latest CU

#SQL Server 2014 build versions: http://support.microsoft.com/kb/2936603

7.2 Max and Min memory

7.3 Default Index Fill Factor (DB Settings)

7.4 Max Degree of Parallelism 

7.5 Compress Backup (in Std. or Ent. edition)

7.6 Model DB properties - Initial Size of DB, Log, and Autogrowth

7.7 TempDB Properties - Initial Size of DB and Autogrowth

7.8 Grant Permissions to the SharePoint Install Account

7.9 Instant File Initialization