Tuesday, May 19, 2015

SQL for SCCM 2016

This step by step guide will provide details for SQL server 2014 installation steps for SCCM 2016 (SCCM TP).

1. Download SQL Server 2014 from https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014
2. Run the setup as Administrator

3. Choose New SQL Server stand-alone installation or add features to an existing installation then click next

4. Specify the edition of SQL Server 2014 to install on Product Key window

5. Accept the License Terms on License Terms window then click next

6. Choose whether you want to install the MS updates or not then click next

7. The setup will check on Install Setup File’s window, click next once the check is done

8. Setup rules will check all the requirements. If you have any errors, you need to fix them before proceeding further. Click next once all the issues addressed

9. On setup role select SQL server Feature Installation then click next

10. On feature selection window select Database Engine Services and all the sub components of it, Analysis Service and Reporting Services - Native then click next

11. Once the feature selection is validated click next on Feature Selection page

12. Set up rules will check for any potential issues. Click next once all the issues are resolved

Note: If you have not installed .NET 3.5, you will get a Failed status as below;

13. On Instance Configuration choose default instance, if you want to use a different name select Named instance and give a unique name then click Next

14. Click Next once the instance configuration validation is complete

15. Specify the service accounts on Server Configuration window

Note: Use only network accounts as a service account. Do not use local accounts, otherwise SCCM prerequisites check will fail
16. Configure SQL collation for database engine as SQL_Latin1_General_CP1_CI-AS and Latin1_General_CI_AS for Analysis Services, then click Next

17. Select accounts to provide access to Database engine by choosing;
Authentication mode: Windows authentication mode and enter network account which has appropriate permissions

18. Accept defaults on Analysis Services Configuration page then click Next

19. Select Install and configure for Reporting Services Native Mode on Reporting Services Configuration Window

20. Review all the component selection on Ready to Install window then click Install

21. Monitor the Installation Progress

22. Review the feature installation status on complete window

No comments:

Post a Comment