Sql Server Installation Preparation: Creating Ramen Firewall Rules, Logische schijven, Installatie .NET-framework 3.5, en serviceaccounts aanmaken.
Create Windows Firewall rules for SQL
1. Logboek in to your Sql server. Rechtermuisknop click on the Begin button and select Control Panel;
2. Open Ramen Firewall;
3. Klikken op Advanced settings;
4. Klikken op Inbound Rules and select New Rule;
5. Select the option Port and click the Volgende knop;
6. Select options UDP, Specific local ports and enter 1434 and click the Volgende knop. (Default Sql UDP port, allow remote connections to Sql);
7. Leave Allow the connection and click the Volgende knop;
8. Leave check marks by default and click Volgende;
9. Enter the rule name, for an example Sql UDP, and click the Finish knop;
10. Repeat and select the TCP optie, Specific local ports, and enter 1433. (Default Sql TCP port). Ook, I enter 14331 En 8080 after the symbol “,” for my future SCCM installatie. Klik de Volgende knop;
11. Repeat, enter the rule name, for example, Sql TCP, and click the Finish knop;
12. Check created tules;
Create logical disks
Create logical disks. Early I created and connected to my Sql VM two “Virtual Disks'. Hierin post, we initialize them and create “Logical disks” in the system.
1. Rechtermuisknop on the “Begin” button and select “Disk Management';
2. First of all change the “CD-ROM” drive letter from “D” to “R'. Rechtermuisknop click on CD-ROM and select Change Drive Letter and Paths;
3. Klik op de Wijziging knop;
4. Select the drive letter “R” and click the OK knop;
5. In the pop-up window click the Yes knop;
6. Klik op de OK button to apply changes;
7. Rechtermuisknop click on the first Disk and select Online;
8. Rechtermuisknop click on the first Disk and select initialize Disk;
9. Select option “GPT (GUID Partition Table)"En klik op"OK” button;
10. Rechtermuisknop click on first Disk “Unallocated space” and select “New Simple Volume” (to create new logical disk);
11. Click the “Volgende” button;
12. Leave size as default and click the “Volgende” button;
13. Assign a drive letter, as an example “D” and click the “Volgende” button;
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'.
Click the “Volgende” button;
15. Check the summary information and click the “Finish” button;
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 of Gui. Hierin post, 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. Click the “Volgende” button;
3. Click the “Volgende” button;
4. Select your target server and click the “Volgende” button;
5. Don’t install any roles, click the “Volgende” button;
6. Set the check mark on “.NET Framework 3.5 Features” and click the “Volgende” button;
7. Click the “Installeren” button (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 “Dichtbij” button;
Create Service Accounts
1. For my Sql & SCCM deployment I create folders:
- On disk “D” ('SCCM-DATA') - SCCM and sub-folders (Backup, Data, Logs);
- On disk “E” ('TEMP') - SCCM;
You plan and deploy Sql as you wish or by your “Corporate Policies'.
2. Let’s add “Serviceaccounts” for Sql En SCCM deployment. Rechtermuisknop click on the “Begin” button and select “Computer Management”;
3. Ga naar "Groups” and open “Administrators';
4. Click the “Toevoegen” button;
5. First add the SCCM server ('AD Object Computer') account. Volgende, add all Sql service accounts and SCCM Serviceaccounts (for client installation); After adding click the 'OK” button;
6. Also you may enable in “Ramen Firewall” rule to allow ping;
7. And enable more rules (see screenshot) for successful SCCM deployment.
8. If you don’t do step “7” you may get the next fout when installing SCCM;
