SQL Server Installation Preparation: Creating Windows Firewall Rules, Logical Disks, Installing .NET Framework 3.5, and Creating Service Accounts.
Create Windows Firewall rules for SQL
1. Log in to your SQL server. Höger musknapp Klicka på Start knappen och välj Kontrollpanel;
2. Öppen Windows brandvägg;
3. Klicka på Advanced settings;
4. Klicka på Inbound Rules och välj New Rule;
5. Välj alternativet Port och klicka på Nästa knapp;
6. Select options UDP, Specific local ports och gå in 1434 och klicka på Nästa knapp. (Default SQL UDP port, allow remote connections to SQL);
7. Leave Allow the connection och klicka på Nästa knapp;
8. Leave check marks by default and click Nästa;
9. Enter the rule name, for an example SQL UDP, och klicka på Avsluta knapp;
10. Repeat and select the TCP alternativ, Specific local ports, och gå in 1433. (Default SQL TCP port). Också, I enter 14331 och 8080 after the symbol “,” for my future SCCM installation. Klick de Nästa knapp;
11. Repeat, enter the rule name, till exempel, SQL TCP, och klicka på Avsluta knapp;
12. Check created tules;
Create logical disks
Create logical disks. Early I create och connect to my SQL VM two “Virtual Disks". I detta inlägg, we initialize them and create “Logical disks” in the system.
1. Höger musknapp on the “Start” button and select “Disk Management";
2. First of all change the “CD-ROM” drive letter from “D” to “R". Höger musknapp click on CD-ROM and select Change Drive Letter and Paths;
3. Klicka på Förändra knapp;
4. Select the drive letter “R” and click the OK knapp;
5. In the pop-up window click the Ja knapp;
6. Klicka på OK button to apply changes;
7. Höger musknapp click on the first Disk and select Online;
8. Höger musknapp click on the first Disk and select initialize Disk;
9. Select option “GPT (GUID Partition Table)" och klicka på "OK" knapp;
10. Höger musknapp click on first Disk “Unallocated space” and select “New Simple Volume” (to create new logical disk);
11. Klicka på "Nästa" knapp;
12. Leave size as default and click the “Nästa" knapp;
13. Assign a drive letter, as an example “D” and click the “Nästa" knapp;
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".
Klicka på "Nästa" knapp;
15. Check the summary information and click the “Avsluta" knapp;
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. I detta inlägg, 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. Klicka på "Nästa" knapp;
3. Klicka på "Nästa" knapp;
4. Select your target server and click the “Nästa" knapp;
5. Don’t install any roles, Klicka på "Nästa" knapp;
6. Set the check mark on “.NET Framework 3.5 Features” and click the “Nästa" knapp;
7. Klicka på "Installera" knapp (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” <drive letter>:\sources\sxs);
8. When the installation is complete click the “Stänga" knapp;
Create Service Accounts
1. For my SQL & SCCM deployment I create folders:
- On disk “D” ("SCCM-DATA") – SCCM and sub-folders (Säkerhetskopiering, 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. Höger musknapp click on the “Start” button and select “Computer Management”;
3. Gå till "Groups” and open “Administrators";
4. Klicka på "Lägg till" knapp;
5. First add the SCCM server ("AD Object Computer") konto. Nästa, add all SQL service accounts and SCCM service accounts (for client installation); After adding click the "OK" knapp;
6. Also you may enable in “Windows brandvägg” rule to allow ping;
7. And enable more rules (se skärmdump) for successful SCCM deployment.
8. If you don’t do step “7” you may get the next error when installing SCCM;