SQL Server 2019 installation and basic configuration (the simplest in history!!!)

downloadSQL Server 2019 Developer

Click download now.

Double click Start

choicebasicInstallation type

Select the appropriate installation path and click Install

Long wait to enter

Save the screenshot of the information in the figure below (do not close this interface first), and click Install SSMS to start installing SSMS.

Click to download SSMS

Select the appropriate path to start the installation

Then there is a long wait (don’t tell me you’re fast, maybe your computer performance is too good)

Click restart to restart the computer (some computers do not need to be restarted, but my computer does anyway)

After restarting, you can see these things in the windows start menu and the installation is over.

Now start testing and using SQL server

Select SQL Server 2019 configuration manager from the start menu

Click SQL server network configuration → MSSqlServer protocol → enable TCP / IP protocol.

Start Microsoft SQL Server Management Studio 18

Click direct connection

The following figure shows that the connection is successful.

Let’s start with some basic configurations

Select Properties

Click Security → check SQL server and windows authentication mode → click OK

The information in the figure below appears. Click OK to restart SQL server

Open our SQL Server 2019 configuration manager again, select SQL Server service → click SQL Server → right-click restart

Go back to Microsoft SQL Server Management Studio 18 and click Security → login → SA (SA is the system default)

Click status → login name → enable check → OK

Close Microsoft SQL Server Management Studio 18 and reopen it. Select SQL server authentication. The login name is SA and the password is the one just modified.

As shown in the figure below, this installation and basic configuration is over