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
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