Priprava na namestitev strežnika SQL: Ustvarjanje pravil požarnega zidu Windows, Logični diski, Namestitev .NET Framework 3.5, in Ustvarjanje storitvenih računov.
Create Windows Firewall rules for SQL
1. Log in to your SQL server. Desni gumb miške kliknite na Začetek gumb in izberite Nadzorna plošča;
2. Odprto Požarni zid Windows;
3. Kliknite na Advanced settings;
4. Kliknite na Inbound Rules in izberite New Rule;
5. Izberite možnost Port in kliknite Naslednji gumb;
6. Select options UDP, Specific local ports and enter 1434 in kliknite Naslednji gumb. (Default SQL UDP port, allow remote connections to SQL);
7. Leave Allow the connection in kliknite Naslednji gumb;
8. Leave check marks by default and click Naslednji;
9. Enter the rule name, for an example SQL UDP, in kliknite Končaj gumb;
10. Repeat and select the TCP možnost, Specific local ports, and enter 1433. (Default SQL TCP port). tudi, I enter 14331 in 8080 after the symbol “,” for my future SCCM installation. Kliknite the Naslednji gumb;
11. Repeat, enter the rule name, na primer, SQL TCP, in kliknite Končaj gumb;
12. Check created tules;
Create logical disks
Create logical disks. Early I create in connect to my SQL VM two “Virtual Disks“. V tej objavi, we initialize them and create “Logical disks” in the system.
1. Desni gumb miške on the “Začetek” button and select “Upravljanje diskov“;
2. First of all change the “CD-ROM” drive letter from “D” to “R“. Desni gumb miške click on CD-ROM and select Change Drive Letter and Paths;
3. Kliknite na spremeniti gumb;
4. Select the drive letter “R” and click the v redu gumb;
5. In the pop-up window click the ja gumb;
6. Kliknite na v redu button to apply changes;
7. Desni gumb miške click on the first Disk and select Online;
8. Desni gumb miške click on the first Disk and select initialize Disk;
9. Select option “GPT (GUID Partition Table)« in kliknite »v redu”.;
10. Desni gumb miške click on first Disk “Unallocated space« in izberite »New Simple Volume” (to create new logical disk);
11. Kliknite »Naslednji”.;
12. Leave size as default and click the “Naslednji”.;
13. Assign a drive letter, as an example “D« in kliknite »Naslednji”.;
14. Set format options:
- File System – leave “NTFS“, if you use “ReFS” – you can’t backup it with “DPM” (Data Protection Manager doesn’t understand ReFS);
- Allocation unit size – I set “64K” because I place on disk a few big files;
- Volume label – set the name for your drive. In my case “SCCM-DATA“.
Kliknite »Naslednji”.;
15. Check the summary information and click the “Končaj”.;
16. Repeat for the second disk;
17. Open “This PC” and check newly added “Logical Disks”;
Install Net Framework 3.5
You can install it using CMD or GUI. V tej objavi, we install “NET Framework 3.5” from GUI.
1. If Server Manager doesn’t start at login – run it. Click on the upper menu “Manage” and select “Add Roles and Features”;
2. Kliknite »Naslednji”.;
3. Kliknite »Naslednji”.;
4. Select your target server and click the “Naslednji”.;
5. Don’t install any roles, kliknite "Naslednji”.;
6. Set the check mark on “.NET Framework 3.5 Features” and click the “Naslednji”.;
7. Kliknite »Namestite”. (if you don’t have an internet connection, but insert DVD or *.iso file with operating system installation files – click “Specify an alternate source path” <črka pogona>:\virisxs);
8. When the installation is complete click the “Zapri”.;
Create Service Accounts
1. For my SQL & SCCM deployment I create folders:
- On disk “D” (“SCCM-DATA“) – SCCM and sub-folders (Rezerva, Data, Logs);
- On disk “E” (“TEMP“) – SCCM;
You plan and deploy SQL as you wish or by your “Corporate Policies“.
2. Let’s add “Service accounts” for SQL and SCCM deployment. Desni gumb miške click on the “Začetek” button and select “Computer Management”;
3. Pojdi do "Groups" in odpri "Administrators“;
4. Kliknite »Dodaj”.;
5. First add the SCCM server (“AD Object Computer“) account. Naslednji, add all SQL service accounts and SCCM service accounts (for client installation); After adding click the “v redu”.;
6. Also you may enable in “Požarni zid Windows” rule to allow ping;
7. And enable more rules (glejte posnetek zaslona) for successful SCCM deployment.
8. If you don’t do step “7” you may get the next error when installing SCCM;