SQL Server 2014 Installation on Windows Server 2012 R2 for SharePoint

Step By Step SQL Server 2014 Installation for SharePoint

1. Mount your SQL Server img.

2. Click on setup and Run as Administrator.

3. On SQL Server Installation Center page, click on Installation.

4. Click on SQL Server stand-alone installation or add feature to an existing installation

5. On SQL Server 2014 Setup page, Enter the product key or Specify a free edition.

Note: Evaluation will be expired in 180 days.

6. On License Terms page, checked I accept the license terms.

7. On Microsoft Update page, check the Use Microsoft Update to check for updates (recomended)

8. On Install Rules page, check the total passes, Failed, Warning and Skiped.

And correct accordingly.

9. If all passed click next.

10. On Setup Role page, choose SQL Server Feature Installation.

11. On Feature Selection select below features.

• SQL Server Replication
• Full-Text and Semantic Extraction for Search
• Client Tools Connectivity
• Integration Services
• Documentation Component.
• Client Tools Connectivity.
• Management Tools-Basic and Click Next

Note: You can add features as per your requirement However Database Engine Services is only essential requirement for SharePoint Server. 

12. On Feature Rules page If you get Error

“Microsoft .NET Framework 3.5 Service Pack 1 is required”

Ok No worry Lets install Microsoft .NET Framework 3.5 Service Pack 1.

a. Click on Windows Server Manager Dashbord-->Manage--> On Add Roles and Feature Wizard page, Next-->Next-->Next-->Next-->.

b. On Features page checked .NET Framework 3.5 Features-->Next

c. On Confirmation installation selections page, Click Specify an alternate source path.

d. Copy your Windows Server 2012R2 in any drive and mount it. Click on source folder then sxs folder and copy the path.

e. Provide path to alternate access and click Install. .NET Framework 3.5 Features will install successfully. Close window.

13. Again start Installing SQL Server 2014.Repeat Steps 1 to 11.

14. Now you will get Instance Configuration Page, Either Change it or let it be Default instance and click Next.

15. On Server Configuration page, Check Account Name Password and Collation. I let it be Default. Will Change later

16. Add Current User or any user as Administrator in My case using Windows authentication Mode and current user is Administrator->Next

17. On Ready to Install page, review your Features and click Install.

18. On Installation progress page look at progress, take a while to install.

19. Check your Log.

 

by Amir Reza via Everyone's Blog Posts - SharePoint Community