Guide to Install SQL Server 2012 for SCCM 2012 R2 | Step-by-Step Tutorial

Guide to Install SQL Server 2012 for SCCM 2012 R2 | Step-by-Step Tutorial. We will be installing SQL server 2012 Standard edition x64 with the 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 added standard TCP and UDP SQL Server ports);
• Create an 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 DBs and 1 for Temp DBs);

Installation:

1. Mount *iso or insert DVD with SQL Server installation files. Go to the 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 check run and are verified you may see details by clicking on the button Show Details or click OK to continue the installation;

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

5. At the next step SQL Install Setup Files.

6. For Setup Support Rules you may see a 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 a check mark to Send feature data to Microsoft, click Next;

9. For Setup Role leave the 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 clicking Next;

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

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

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

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

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

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

18. For Error Reporting set a 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 is OK click Install;

21. Installation begins;

22. When the installation is complete click Close and reboot the system;

23. After reboot check installed SQL Server 2012;