SQL Server Installation Preparation: Creating Windows Firewall Rules, Logical Disks, Installing .NET Framework 3.5, and Creating Service Accounts

SQL Server Installation Preparation: Creating Windows Firewall Rules, Logical Disks, Installing .Estrutura NET 3.5, and Creating Service Accounts.

Create Windows Firewall rules for SQL

1. Registro para o seu SQL servidor. Botão direito do mouse clique no Começar botão e selecione Painel de controle;

2. Abrir Windows Firewall;

3. Clique em Advanced settings;

4. Clique em Inbound Rules e selecione New Rule;

5. Selecione a opção Port e clique no Próximo botão;

6. Select options UDP, Specific local ports and enter 1434 e clique no Próximo botão. (Padrão SQL UDP port, allow remote connections to SQL);

7. Leave Allow the connection e clique no Próximo botão;

8. Leave check marks by default and click Próximo;

9. Enter the rule name, for an example SQL UDP, e clique no Terminar botão;

10. Repeat and select the TCP opção, Specific local ports, and enter 1433. (Padrão SQL Porta TCP). Também, I enter 14331 e 8080 after the symbol “,” for my future SCCM instalação. Clique o Próximo botão;

11. Repeat, enter the rule name, por exemplo, SQL TCP, e clique no Terminar botão;

12. Check created tules;

Create logical disks

Create logical disks. Early I created and connected to my SQL VM two “Virtual Disks“. Nesta publicar, we initialize them and create “Logical disks” in the system.

1. Botão direito do mouse on the “Começar” button and select “Disk Management“;

2. First of all change the “CD-ROM” drive letter from “D” to “R“. Botão direito do mouse click on CD-ROM and select Change Drive Letter and Paths;

3. Clique no Mudar botão;

4. Select the drive letter “R” and click the OK botão;

5. In the pop-up window click the Sim botão;

6. Clique no OK button to apply changes;

7. Botão direito do mouse click on the first Disk and select Online;

8. Botão direito do mouse click on the first Disk and select initialize Disk;

9. Select option “GPT (GUID Partition Table)”E clique em“OK" botão;

10. Botão direito do mouse click on first Disk “Unallocated space” and select “New Simple Volume” (to create new logical disk);

11. Clique no “Próximo" botão;

12. Leave size as default and click the “Próximo" botão;

13. Assign a drive letter, as an example “D” and click the “Próximo" botão;

14. Set format options:

• File System – leave “NTFS“, if you use “ReFS” – you can’t backup it with “PMD” (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“.

Clique no “Próximo" botão;

15. Check the summary information and click the “Terminar" botão;

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 DMC ou GUI. Nesta publicar, we install “Estrutura NET 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. Clique no “Próximo" botão;

3. Clique no “Próximo" botão;

4. Select your target server and click the “Próximo" botão;

5. Don’t install any roles, Clique no “Próximo" botão;

6. Set the check mark on “.NET Framework 3.5 Features” and click the “Próximo" botão;

7. Clique no “Instalar" botão (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>:\fontessxs);

8. When the installation is complete click the “Fechar" botão;

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 “Service accounts” for SQL e SCCM deployment. Botão direito do mouse click on the “Começar” button and select “Computer Management”;

3. Vá para "Groups” and open “Administrators“;

4. Clique no “Adicionar" botão;

5. First add the SCCM servidor (“AD Object Computer“) conta. Próximo, add all SQL service accounts and SCCM service accounts (for client installation); After adding click the “OK" botão;

6. Also you may enable in “Windows Firewall” rule to allow ping;

7. And enable more rules (Veja a captura de tela) for successful SCCM deployment.

8. If you don’t do step “7” you may get the next erro when installing SCCM;