Preparación de instalación de SQL Server: Creación de reglas de firewall de Windows, Discos lógicos, Instalación de .NET Framework 3.5, y crear cuentas de servicio

SQL Server Installation Preparation: Creating ventanas Firewall Rules, Discos lógicos, Installing .NET marco 3.5, y crear cuentas de servicio.

Create Windows Firewall rules for SQL

1. Registro en tu SQL servidor. Botón derecho del ratón haga clic en el Comenzar botón y seleccione Panel de control;

2. Abierto ventanas Cortafuegos;

3. Hacer clic en Advanced settings;

4. Hacer clic en Inbound Rules y seleccionar New Rule;

5. Seleccione la opción Puerto and click the Próximo botón;

6. Select options UDP, Specific local ports and enter 1434 and click the Próximo botón. (Por defecto SQL UDP port, allow remote connections to SQL);

7. Leave Allow the connection and click the Próximo botón;

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

9. Enter the rule name, for an example SQL UDP, and click the Finalizar botón;

10. Repeat and select the TCP opción, Specific local ports, and enter 1433. (Por defecto SQL Puerto TCP). También, I enter 14331 y 8080 after the symbol “,” for my future SCCM instalación. Hacer clic el Próximo botón;

11. Repeat, enter the rule name, Por ejemplo, SQL TCP, and click the Finalizar botón;

12. Check created tules;

Create logical disks

Create logical disks. Early I created and connected to my SQL máquina virtual two “Virtual Disks“. en esto correo, we initialize them and create “Logical disks” in the system.

1. Botón derecho del ratón on the “Comenzar” button and select “Disk Management“;

2. First of all change the “CD-ROM” drive letter from “D" a "R“. Botón derecho del ratón click on CD-ROM and select Change Drive Letter and Paths;

3. Haga clic en el Change botón;

4. Select the drive letter “R” and click the DE ACUERDO botón;

5. In the pop-up window click the Sí botón;

6. Haga clic en el DE ACUERDO button to apply changes;

7. Botón derecho del ratón click on the first Disk and select Online;

8. Botón derecho del ratón click on the first Disk and select initialize Disk;

9. Select option “GPT (GUID Partition Table)"Y haga clic" "DE ACUERDO" botón;

10. Botón derecho del ratón click on first Disk “Unallocated space” and select “New Simple Volume" (to create new logical disk);

11. Haga clic en "Próximo" botón;

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

13. Assign a drive letter, as an example “D" y haga clic en "Próximo" botón;

14. Set format options:

• Sistema de archivos – 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“.

Haga clic en "Próximo" botón;

15. Check the summary information and click the “Finalizar" botón;

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 o GUI. en esto correo, we install “NET marco 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. Haga clic en "Próximo" botón;

3. Haga clic en "Próximo" botón;

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

5. Don’t install any roles, haga clic en "Próximo" botón;

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

7. Haga clic en "Instalar" botón (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>:\fuentessxs);

8. When the installation is complete click the “Cerca" botón;

Create Service Accounts

1. For my SQL & SCCM deployment I create folders:

• On disk “D" (“SCCM-DATA“) – SCCM and sub-folders (Respaldo, Datos, Registros);

• 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 y SCCM despliegue. Botón derecho del ratón click on the “Comenzar” button and select “Computer Management”;

3. Ir a "Groups” and open “Administradores“;

4. Haga clic en "Agregar" botón;

5. First add the SCCM servidor (“AD Object Computer“) cuenta. Próximo, add all SQL service accounts and SCCM service accounts (for client installation); After adding click thmi “DE ACUERDO" botón;

6. Also you may enable in “ventanas Cortafuegos” rule to allow ping;

7. And enable more rules (see screenshot) for successful SCCM despliegue.

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