01. Install SQL Server

This article explains how to install SQL Server.

SQL Server editions

SQL Server has several editions. In this blog, we will use the Developer Edition. Other free editions are Express Edition or Evaluation Edition.

Editions and supported features of SQL Server 2022 - SQL Server

Learn details of the features supported by the various editions of SQL Server 2022.

learn.microsoft.com

Download installer

1. Access the following URL and click the “Download now” button.
   https://www.microsoft.com/en-us/sql-server/sql-server-downloads
   
   
2. When the file(.exe) download is complete, execute the exe file.
   
   
3. Click “Download Media”.
   
   
4. Select “ISO” and click “download” button.
   
   
5. When the message “Download successful” is displayed, click “close” button.
   
   

Install SQL Server

1. Right click on SQLServer2022-x64-{loc}.iso and select Mount.
   
   
2. Locate and execute setup.exe on the mounted device to begin the installation. 
   
   
   
   
3. Click “New SQL Server standalone installation or add features to an existing installation”.
   
   
   
   
4. Specify “Developer” and click “Next” button.
   
   
   
   
5. Check “I accept the license terms and Privacy Statement” and click the “Next” button.
   
   
6. Do not check “Use Microsoft Update to check for updates (recommended) ” and click the “Next” button. * We will apply update after installing SQL Server.
   
   
7. Click “Next” on the “Install Rules” screen.
   
   
8. Uncheck “Azure Extension for SQL Server” if you don’t need Azure extension and click the “Next” button.
   
   
   
   
9. Check only “Database Engine Services” and click the “Next” button.
   
   
   
   
10. Check “Default instance” and click the “Next” button.
    
    
    
    
11. Click “Next” on the “Server Configration” screen.
    
    
12. Check “Mixed Mode (SQL Server authentication and Windows authentication)” and set a password of your choice. Additionally, click the “Add Current User” button. Then click the “Next” button.
    
    
    
    
13. Click “Install” on the “Ready to Install” screen.
    
    
    
    
14. Confirm that the installation has been completed without any error and click the “Close” button.