Installing the Database SQL Server 2019

To do this installation, it was necessary to create a Windows Operating System on a virtual machine if you do not have or do not know how to click on a Virtual Machine access the link (Create VM) on our website that shows how to prepare.


Let's see the prerequisites for installing the Database SQL SERVER.


Hard disk and Processor

  • SQL Server requires a minimum of 6 GB of available hard disk space.

  • Minimum: x64 processor: 1.4 GHz;

  • Minimum processor speed: x64 processor: 1.4 GHz;

  • Recommended: 2.0 GHz or faster;

Memory * Minimum:

  • Express editions: 512 MB

  • All other editions: 1 GB

  • Recommended: Express editions: 1 GB

All other editions: At least 4 GB and must be increased as the database size increases to ensure optimum performance.

Note
The SQL Server installation is supported on x64 processors only. It is no longer supported with x86 processors.

Operating System:


Windows 10 operating system TH1 1507 or higher

Windows Server 2016 or higher


As the S.O Windows installed on the virtual machine we will now do the installation if you do not have the Database it is possible to download the Database SQL Server beforehand from the official website of Microsoft for 180 days trial version. (Download SQL Server Reviews).


Configuring Installing Database Software SQL SERVER 2019.


Once the Database is downloaded, the version that will be installed is SQL SERVER 2019.

Let's start the installation step by step.


Install SQL Server 2019

Step 1:

Click on the tab on the left Installation.

Step 2:

Now let's do a new installation by clicking on (New SQL Server stand-alone installation or add feature to an existing).


Step 3:

In this step you will be asked for your product key. For free use you can choose between the two options.

The first and EVALUATION has the greatest feature of SQL SERVER However, 180 days expiration.

The DEVELOPER edition is complete and has all the features found in the Enterprise edition of SQL Server. This allows everyone to have the opportunity to know and study all the features that SQL Server offers, such as Analysis Services, Reporting Services, Integration Services, Master Data Services, Data Quality Services, etc., at no cost. Let's choose DEVELOPER. "Next" button.

Step 4:

Read the License term for using the Microsoft Software, check Flag and click on the "Next" button.


Step 5:

Always check the flag (Use Microsoft Update to check for updates) so that when installing the product you can make the updates that are necessary. "Next" button.


Step 6:

The installer will now verify all installation requirements and replenish any potential problems that may exist. A WARNING will appear on the firewall ignore. "Next" button.

Step 7:

As we are going to do the installation of the Database, we mark the Flag (Database Engine Services) also the directories where the entire database installation will be.ignore and proceed. "Next" button.


Step 8:

Now put the name of your Instance of the SQL Server Database, this is up to you, in this installation I will leave the name that was suggested. "Next" button.



Step 9:

We are going to do the configuration of the SQL Server account services, I will leave it default because it is an educational installation. For details of setting up services and accounts click on the installer (Click here for details) which is highlighted in blue. "Next" button.

Step 10:

Specify the security mode of authentication, we will mark the mode (Mixed mode) so that we can connect with a user of the local Windows Operating System as a standard user of SQL SERVER (SA) include a password. Click (Add a Current User) to include the SQL Server Administrator user for your local machine."Next" button.


Step 11:

Check the installation summary if the settings are correct. "Next" Install.





Step 12:

Let us wait for the installation progress. A final completion screen will show all the success statuses of the DATABASE SQL SERVER already installed "Next" Close.

We are done with the installation of the new SQL SERVER 2019, the database is ready for use.

We have successfully completed the entire procedure!

3 views