Summary: In this tutorial, you will learn how to install SQL Server 2019 Developer Edition and SQL Server Management Studio (SSMS).
Install SQL Server 2019 Developer Edition Download SQL Server 2019 To download SQL Server
2019, click the following link:Download the
SQL Server that Microsoft provides you with some editions
of
SQL Server
. For learning purposes, you can download the developer edition.
After the download is complete, you can double-click the SQL2019-SSEI-Dev.exe file to launch the downloader.
1. The downloader will ask you to select the installation type, choose the Download media option. This option allows you to download the installation files first and install SQL Server later.
<img src="https://www.sqlservertutorial.net/wp-content/uploads/download-sql-server-2019.png" alt="Download
” />
2. Specify the folder to store the installation files, and then click the Download:
3. The downloader will start downloading the installation files. It will take a while.
4. After the download is complete, open the folder that stores the downloaded file:
=”https://www.sqlservertutorial.net/wp-content/uploads/download-sql-server-2019-download-completed.png”
5. Right-click the iso file and select the Mount option to mount the iso:
6 file. Open the installation folder and click the setup.exe file to launch the installer:
Install SQL Server 2019 developer edition
1. After double-clicking Settings.exe, you will see the following window; Select the installation option on the left:
2. Click the first link to start a wizard to install SQL Server 2019:
3. Specify the edition you want to install, select Developer Edition, and click the Next button.
4. Select “I accept the license terms” and click the Next button:
=”https://www.sqlservertutorial.net/wp-content/uploads/install-sql-server-2019-step-4.png”
5. Clear “Use Microsoft Update to check for updates (recommended)” if you do not want to get updates for SQL Server, and then click the Next button:
6. Setup checks the prerequisites before installation. If no error occurs, click the Next button:
7. Select the features you want to install. For learning purposes, you need the Database Engine Services; tick the checkbox and click the Next button to continue:
8. Provide the SQL Server instance ID and click the Next button:
9. Select mixed mode, provide the password for the system administration (sa) account (you must store this password in a safe place so that you can use it to connect to SQL Server later), click Add Current User to specify SQL Server administrators, and click the Next button:
10. Check the SQL Server 2019 features to be installed:
11. Click the Close button to complete the installation:
! has successfully installed SQL Server 2019 Developer Edition
.
Install Microsoft SQL Server Management Studio
To interact with SQL Server, you must have a SQL Server client tool.
Microsoft provides you with SQL Server Management Studio (SSMS). SQL Server Management Studio is software for querying, designing, and managing SQL Server on your local computer or in the cloud. Provides you with tools to configure, monitor, and manage instances of SQL Server.
First, download the SSMS from the
Microsoft Web site using the following link:
Download SQL Server Management Studio
Second, double-click the SSMS-Setup-ENU installation file.exe to launch the SSM installer. The SMS installation process is straightforward. You need to follow the sequence of the screen.
1. Click the Install
2. Wait a few minutes while the installer configures the software:
3. After the setup is complete, click the Close:
button
, you should now have SQL Server 2019 and SQL Server Management Studio installed on your computer. Next, you will learn how to connect to SQL Server 2019 from SQL Server Management Studio.