Step by Step - Installing SQL Server 2019
Installing and hardening SQL Server 2019. Step by step installation.
Creating Virtual Server
Log in to vSphere in order to create the virtual server for SQL Server 2019.
After the succesful log in, select the Datacenter to be used and right click on it. Select "New Virtual Machine" from the drop-down menu to create the server.
After the selection the pop-up screen will come up in order to identify the details for the virtual machine. Choose the best option that suits for you. For example if you already have a template SQL Server 2019 it is better to select "Deploy from Template".
This document has been prepared for users who dont have any VM in the enviroment and so "Create a new virtual machine" has been selected.
Step 2. Name the server and select the location for virtual machine. "SQLSRV2019"
Step 3. Select the destionation resource for the virtual machine. The windows will show multiple clusters and resource areas if you have.
Step 4. Select the storage for the configuration.
Step 5. Select the compability depending to your enviroment.
Step 6. Select guest OS. "Microsoft Windows Server 2016 or later" was selected for SQL Server 2019.
Step 7. Configuring the virtual machine hardware. CPU, Memory, Disk, Network custimization needs to be done in that step. To boot directly from ISO file select "New CD/DVD Drive" connected. Requirements should be defined carefully before creating the virtual machine.
| Component | Requirement |
|---|---|
| Hard Disk | SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files. |
| Monitor | SQL Server requires Super-VGA (800x600) or higher resolution monitor. |
| Internet | Internet functionality requires Internet access (fees may apply). |
| Memory * | Minimum: Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance. |
| Processor Speed | Minimum: x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster |
| Processor Type | x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support |
Step 8. Review all the configuration and click finish.
Power on the virtual machine after the process.
Server 2019 Installation
Step 1. Select language, time, currency and keyboard method for the Server 2019.
Step 2. Click "Install Now" to start the process.
Step 3. Select the operating system and click next.
Step 4. Review and accept the license terms and click next.
Step 5. Select the installation type for operating system. "Custom" was selected for this post.