In this post we will see that how to download and install SQL Server 2019, so follow steps below
we will perform installation in two steps:
- Install SQL server (SQL Server Instance)
- Install SQL Server Management Studio (SSMS)
Step 1 Download SQL Server 2019
there are two edition available
- Developer Edition : SQL Server 2019 Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment.
- Express Edition : SQL Server 2019 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.
Download Link : https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Now Run Setup File and click on custom
it will take some time to download installation package
navigate to installation > New stand-alone installation
select your downloaded edition and continue (I have Downloaded Developer edition)
Now Select Mixed Mode and set password which will require later to login in SQl Server. then Click on Add Current User then click next
once setup is Successfully Installed, go to Start menu > Services and check if instance is running, if instance is there and running then your sql server instance is successfully installed.
Step 2 Download Sql Server Management Studio
go to browser and search “sql server management studio” or click on below link:
Download link : https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
Perfom Installation step by step
After Setup complete go to start menu > SSMS
now login with your username and password (which you have set during installation).
that’s it , Your SQL server installation process is complete.
see below video for better explanation:
if you face any error during installation then comment your query below i will try to help you.
I hope this post is helpful