Průvodce instalací SQL Serveru 2012 pro SCCM 2012 R2 | Výukový program krok za krokem. 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, taky, 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;
- Taky, I create (add) two disks (1 pro SCCM DATA DBs a 1 pro Temp DBs);
Instalace:
- Mount *iso or insert DVD with SQL Server installation files. Go to the folder and run the založit.exe s Spustit jako administrátor;
2. Vybrat Instalace a klikněte naNew 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 nebo klikněte OK to continue the installation;
4. After that SQL checks for updates. Klikněte další when complete;
5. At the next step SQL Install Setup Files.
6. Pro Setup Support Rules you may see a Warning v Brána firewall systému Windows, to je normální, klikněte další;
7. Pro Product Key enter your product key and click další;
8. Pro License Terms read and accept (by settings check mark Souhlasím s licenčními podmínkami) the license terms, also you may set a check mark to Send feature data to Microsoft, klikněte další;
9. Pro Setup Role leave the default option SQL Server Feature Installation a klikněte další;
10. Pro Feature Selection vybrat Služby databázového stroje (with Full-text if you wish), Reporting Services – Native, a Management Tools – Complete. Klikněte další;
11. Pro Installation rules you may see details by pressing Show details and clicking další;
- Choose the option Named Instance and enter its name (V mém případě SCCM). Taky, I change the Instance root directory. Klikněte další;
13. Pro Disk Space Requirements check if it ok and click další;
14. Pro Konfigurace serveru v the Service Accounts tab enter early created accounts. Pro Collation vybrat SQL_Latin1_General_CP1_CI_AS. Klikněte další;
15. Pro Database Engine Configuration v the Server Configuration tab add SQL Server administrators (používám local group administrators and my current user);
16. v Datové adresáře select the new path and click další;
17. Pro Konfigurace Reporting Services choose to Pouze nainstalovat (konfigurujeme později) a klikněte další;
18. Pro Error Reporting set a check mark (if you wish) a klikněte další;
19. Pro Installation Configuration Rules check details and click další;
20. Pro Ready to Install if all is OK click Nainstalujte;
21. Instalace začíná;
22. When the installation is complete click Close and reboot the system;
23. After reboot check installed SQL Server 2012;