2. Install SQL Server 2022 and SQL Server Management Studio (SSMS)
Link download SQL Server 2022: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Download the Express version: https://go.microsoft.com/fwlink/p/?linkid=2216019&clcid=0x409&culture=en-us&country=us (Direct download link)
Link download SQL Server Management Studio (SSMS): https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
Direct download link: https://aka.ms/ssmsfullsetup (SSMS 20.1 version)
- Release number: 20.1
- Build number: 20.1.10.0
- Release date: April 9, 2024
Install SQL Server 2022
Double click the file SQL2022-SSEI-Expr.exe
Select "Custom"
Click "Install"
Click "New SQL Server standalone installation or add features to an existing installation"
Check the checkbox "I accept the license terms and Privacy Statement". Click "Next"
Check "Use Microsoft Update to check for updates (recommended)". Click "Next"
Ignore firewall warning. Click "Next"
Check the checkbox "PolyBase Query Service for External Data" & "LocalDB". Click "Next"
Select "Default instance" to use the default name. Click "Next"
Click "Next"
Set "SQL Server Browser" to Automatic or Enabled. Check the checkbox "Grant Perform Volume Maintenance Tasks privilege to SQL Server Database Engine Service". Click the "Next" button
Select "Mixed Mode (SQL Server authentication and Windows authentication)". Enter an easy-to-remember password. For example: 12345. Re-enter the password in the "Confirm password:" textbox. Click "Next"
Click the "OK" button
Click the "Close" button
Click the "Close" button (X) in the upper right corner of the window
So the installation process of "SQL Server 2022" has been completed.
Install SQL Server Management Studio
Double click the file SSMS-Setup-ENU.exe
Click the "Install" button
So the installation process of "SQL Server Management Studio" has been completed.
Search "SQL Server Management Studio 20" to open "SQL Server Management Studio"