In this guide, we installing SQL Server 2012 for SCCM 2012 R2. To know the supported configurations of SQL server for SCCM 2012 R2 please go through this link: https://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig. We will be installing SQL server 2012 SP3 Standard edition x64 with latest updates.

Some Preparation:

  • Install .Net 3.5 feature;
  • Create rules in Windows Firewall for SCCM connection (I use static port 14331 for DB and 8080 for reporting, also, I’m added standard TCP and UDP SQL Server ports);
  • Create in Active Directory 3 service accounts:

sqlsccmagent – sql agent

sqlsccmsvc – sql service

sqlsccmrep – sql reporting services

  • Add all 3 accounts to Local Group Administrators on my SQL Server machine;
  • Also, I create (add) two disks (1 for SCCM DATA DB’s and 1 for Temp DB’s);

Installation:

  1. Mount *iso or insert DVD with SQL Server installation files. Go to folder and run the setup.exe with Run as administrator;

2. Select Installation and click on New SQL server standalone installation or add features to an existing installation;

3. Once the Setup support rules checks run and verified you may see details by click on button Show Details or click OK to continue the installation;

4. After that SQL checks for updates. Click Next when complete;

5. At next step SQL Install Setup Files.

6. For Setup Support Rules you may see Warning in Windows Firewall, it’s normal, click Next;

7. For Product Key enter your product key and click Next;

8. For License Terms read and accept (by settings check mark I accept the license terms) the license terms, also you may set check mark to Send feature data to Microsoft, click Next;



9. For Setup Role leave default option SQL Server Feature Installation and click Next;

10. For Feature Selection select Database Engine Services (with Full-text if you wish), Reporting Services – Native and Management Tools – Complete. Click Next;

11. For Installation rules you may see details by pressing Show details and click Next;

  1. Choose option Named Instance and enter it name (In my case SCCM). Also, I change Instance root directory. Click Next;

13. For Disk Space Requirements check if it ok and click Next;

14. For Server Configuration in Service Accounts tab enter early created accounts. For Collation select SQL_Latin1_General_CP1_CI_AS. Click Next;

15. For Database Engine Configuration in Server Configuration tab add SQL Server administrators (I use local group administrators and my current user);




16. In Data Directories select new path and click Next;

17. For Reporting Services Configuration choose Install only (we configure it later) and click Next;

18. For Error Reporting set check mark (if you wish) and click Next;

19. For Installation Configuration Rules check details and click Next;

20. For Ready to Install if all OK click Install;

21. Installation begin;

22. When installation complete click Close and reboot system;

23. After reboot check installed SQL Server 2012;

Share on Pinterest
Share with your friends










Submit