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:

• Instalar .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 Diretório Ativo 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 e 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. Selecione Installation and click on Novo 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. Clique Próximo when complete;

5. At the next step SQL Install Setup Files.

6. For Setup Support Rules you may see a Warning em Windows Firewall, it’s normal, clique Próximo;

7. For Product Key enter your product key and click Próximo;

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, clique Próximo;

9. For Setup Role leave the default option SQL Server Feature Installation e clique Próximo;

10. For Feature Selection select Database Engine Services (with Full-text if you wish), Reporting Services – Native, e Management Tools – Complete. Clique Próximo;

11. For Installation rules you may see details by pressing Show details and clicking Próximo;

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

13. For Disk Space Requirements check if it ok and click Próximo;

14. For Server Configuration em the Service Accounts tab enter early created accounts. For Collation select SQL_Latin1_General_CP1_CI_AS. Clique Próximo;

15. For Database Engine Configuration em 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 Próximo;

17. For Reporting Services Configuration choose to Install only (we configure it later) e clique Próximo;

18. For Erro Reporting set a check mark (if you wish) e clique Próximo;

19. For Installation Configuration Rules check details and click Próximo;

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

21. Installation begins;

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

23. After reboot check installed SQL Server 2012;