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