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