Summary: in this tutorial, you will learn to install SQL Server 2022 Developer Edition and SQL Server Management Studio (SSMS).
Install SQL Server 2022 Developer Edition
Download SQL Server 2022
To download SQL Server 2022, click the link below:
Microsoft offers some editions of SQL Server. For learning purposes, you can download the Developer edition.
Step 1. The downloader will ask you to select the installation type. Choose the Download Media option, which allows you to download the setup files first and install the SQL Server later:
Step 2. Choose the folder to store the installation files, then click the Download button:
Step 3. The downloader will start downloading the installation files. This process may take some minutes, depending on your internet speed.
Step 4. Once the download is complete, open the folder where the downloaded file is stored:
Step 5. Open the SQLServer2022-DEV-x64-ENU file to launch the installation. It will extract the files to a directory and start the installation process.
Install SQL Server 2022 developer edition
Step 1. After launching the installer, the SQL Server Installation Center window appears; select the Installation option on the left:
Step 2. Select the Developer edition to install and click the Next button:
Step 3. Check the “I accept the license terms.” and click the Next button:
Step 4. If you don’t want to get the updates for the SQL Server, uncheck the “Use Microsoft Update to check for updates (recommended)” option, and then click the Next button:
Step 5. The installation will check for prerequisites before proceeding. If no error occurs, click the Next button:
Step 6. Uncheck the Aruze extension for SQL Server:
Step 7. Select the features you want to install. For learning purposes, you need the Database Engine Services, and click the Next button to continue:
Step 8. Enter the instance ID of the SQL Server and click the Next button. The instance ID defaults to MSSQLServer:
Step 9. Specify the service accounts and collation configuration. Use the default settings and click the Next button:
Step 10. Specify database engine authentication security mode. Select the Mixed Mode (1), and enter the password for system administration (sa) account (2& 3), and add the current user as a SQL Server Administrator (4):
Make sure to store this password in a secure place, as you’ll need it to connect to the SQL Server later.
Step 11. Verify that the SQL Server 2022 features are installed.
Step 12. Click the Close button to complete the installation.
Congratulation! you have successfully installed SQL Server 2022 Developer Edition.
Microsoft SQL Server Management Studio (SSMS)
To interact with SQL Server, you can use a SQL Server client tool such as SQL Server Management Studio (SSMS) provided by Microsoft.
The SQL Server Management Studio is software for querying, designing, and managing SQL Server on your local computer, a remote server, or in the cloud. It provides you with tools to configure, monitor, and administer SQL Server instances.
Download SQL Server Management Studio
First, download the SSMS from the Microsoft website via the following link:
Download SQL Server Management Studio
Second, double-click the installation file SSMS-Setup-ENU.exe to launch the installer. The installation process of SMSS is straightforward. you need to follow the screen sequence.
Install SQL Server Management Studio
Step 1. Click the Install button:
Step 2. Wait for a few minutes while the installer setting up the software:
Step 3. Once setup is completed, click the Close button:
Now, you should have SQL Server 2022 and SQL Server Management Studio installed on your computer. Next, you will learn how to connect to the SQL Server from the SQL Server Management Studio.
