We need to install 2 files above.
Step 1: Download installation
SQL2019-SSEI-Expr.exe: Express Edition
SQL2019-SSEI-Dev.exe: Developer Edition
Phiên bản: Dev
https://download.microsoft.com/download/d/a/2/da259851-b941-459d-989c-54a18a5d44dd/SQL2019-
SSEI-Dev.exe
Phiên bản: Express
https://download.microsoft.com/download/7/f/8/7f8a9c43-8c8a-4f7c-9f92-83c18d96b681/SQL2019-
SSEI-Expr.exe
We choose Dev version
Step 2:
Run the downloaded file and you will see the below screen.
Here, you have three choices.
Basic
Custom
Download Media
Select the following
This will download the install package. The install package automatically starts the
SQL Server installation center
Step 3: Start to setup
Choose Next
Install Rules:
Step 4
Now you will see the Product Key window. Select the Developer option from the dropdown and click on
the Next button.
Accept the License Terms.
Step 5: Features Selection
Select 5 following:
Database Engine Services
Client Tools Connectivity
Client Tools for backward compatibility
SQL Client Connectivity SDK
Client Tools SDK
Step 6: Instance Configuration
It will check some feature rules/prerequisites and then you will see the Instance Configuration screen.
Here you can choose between Default Instance and Named Instance.
You can have multiple instances of the SQL Server running in the system. Each must have its own
instance name
You can have one default instance. The default instance name is MSSQLSERVER. If you choose this, then
you can then use your computer name (or IP address) to connect to that instance
All other instances must be named. You can then use name /<instanceName> to connect to that
instance.
Default Instance
When SQL Server is installed in the default instance, it does not require a client to specify the name of
the instance to make a connection. The client only has to know the server name. For example, HARDIK-
PC.
Named Instance
A named instance is identified by the network name of the computer plus the instance you specify
during the installation. The client must specify both the server name and the instance name when
connecting. For example, HARDIK-PC/MSSQLSERVER.
Here I will go with Named Instance is SQL2019
We connect to the SQL Server using the <computerName>\<InstanceName> as server name
For Example, if the computer name is HOME and the instance name is SQL2019 then SQL server name is
HOME\SQL2019
Step 7: Server Configuration
Next, you will see the Server Configuration window. In Service Accounts tab, select Automatic in Startup
Type for SQL Server Agent, SQL Server Database Engine, and SQL Server Browser services.
Step 8: Database Engine Configuration
Windows Authentication
the windows user is automatically recognized by SQL Server. The Windows security identifier
(SID) is passed from Windows to SQL Server. The SQL Server does not store any user information
and trusts the Windows user. The SA user gets disabled when you use this
Mixed Mode ( Windows Authentication and SQL Server authentication Mode)
In this mode, along with the Windows Users, the SQL Server also stores the user name &
password in the database. In this scenario, you can connect to SQL Server either using the
Windows account and using the user name/password stored in SQL Server itself
Sa(system administration) account
Choose Mixed Mode
- You have to enter the SA user password: ex: 1234567
- Also, click on Add Current User to add the Current Logged in User to SQL Server
Change the default folders used by the SQL Server from the tab Data Directories
In the Data Directories tab, specify locations for database files and backup files. By default, it saves all
the files on a C drive but it is not recommended to store database files on an OS drive because if any OS-
related issue occurs then we may lose our data. Therefore, I choose D drive on my local machine.
In the TempDB tab, there are configurations for the temporary database file(s). There are some best
practices on how to configure temporary database files locations, the number of files, and their file
sizes. Ideally, the number of the TempDB data files should match the number of logical processors. So I
have a number of files to 2. If you are interested in deep dive into TempDB best practices, here is a very
good article on it.
Next
once review the summary and click on the Install button.
Step 9: Once the installation is complete, you will see the following window.
Step 10: Download and set up SQL Server Management Studio
https://aka.ms/ssmsfullsetup
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-
server-ver15
SSMS 19.1 is the latest general availability (GA) version
Click install
Installation completes
Lauch SQL 2019
Select
Or select SQL Sever Authentication, type sa and password for login.
References:
https://www.c-sharpcorner.com/article/step-by-step-installation-of-microsoft-sql-server-on-windows-
system/
https://www.tektutorialshub.com/sql-server/how-to-download-and-install-sql-server-
2019/#:~:text=Download%20SQL%20Server%202019,-
SQL%20Server%202019&text=You%20can%20also%20download%20from,select%20developer%20or%2
0express%20edition.
