Guide Installing SQL Server 2012 for Configuration Manager 2012 R2

Guide Installing SQL Server 2012 for Configuration Manager 2012 R2. For 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;

You might also like

Leave a Reply

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More