Skip to content

Install and Configure SQL Server 2022 Express

Limitations

SQL Server 2022 Express with Advanced Services is limited to a maximum database size of 10 GB. If you want to use more than 10GB, you need to migrate to a higher edition or Microsoft Azure SQL Database.

Download SQL Server 2022 Express with Advanced Services

  1. Access the following URL and click the "Download" button for the Express edition.
    https://www.microsoft.com/en-us/download//details.aspx?id=104781
  2. When the file download is complete, click the "Run (R)" button.
  3. When the message "Do you want to allow the following program to make changes to this computer?" is displayed, click the "Yes (Y)" button.
  4. Click "Download Media (D)".
    The first screen of the SQL Server 2022 Express installer, where "Download Media (D)" can be selected
  5. Check "Express Advanced" and click the "Download (D)" button.
    The media download screen with "Express Advanced" checked
  6. Wait until the download is complete.
    Progress screen while the media is downloading
  7. When the message "Download succeeded" is displayed, click the "Open Folder" button.
    The screen showing "Download succeeded", with an "Open Folder" button

Install SQL Server 2022 Express with Advanced Services

  1. Double-click "SQLEXPRADV_x64_JPN".

    The download folder opened in Explorer, containing "SQLEXPRADV_x64_JPN"
  2. The "Select Directory for Extracted Files" dialog will appear, so click the "OK" button.

    The "Select Directory for Extracted Files" dialog
  3. Wait until preparation for extraction is complete.
    Progress screen while the files are being extracted
  4. Click "Run a new stand-alone installation of SQL Server or add features to an existing installation".
    The installation type screen listing the new stand-alone installation option
  5. Check "I accept the license terms (A)" and click the "Next (N)>" button.
    The license terms screen with the "I accept the license terms" checkbox
  6. Click "Next (N)" on the "Installation Rules" screen.
    The "Installation Rules" screen listing the results of the pre-installation checks
  7. Uncheck "Azure Extension for SQL Server" and click the "Next (N)>" button.
    The screen where "Azure Extension for SQL Server" can be disabled
  8. Check only "Database Engine Services" and "Full-text and Semantic Extractions for Search" and click the "Next (N)>" button.
    The feature selection screen with "Database Engine Services" and full-text extraction checked
  9. Check "Default Instance (D)" and click the "Next (N)>" button.
    The instance configuration screen with "Default Instance (D)" selected
  10. Click the "Next (N)>" button.
    The settings screen shown after choosing the instance
  11. Check "Mixed Mode (SQL Server Authentication and Windows Authentication) (M)" and set a password of your choice. Please note the password you set as it will be used in "Install Pleasanter". Then click the "Next (N)>" button.
    The authentication mode screen where "Mixed Mode" is selected and a password is set
  12. Wait until the installation is complete.
    Progress screen while the installation is running
  13. Confirm that the installation has been completed and click the "Close" button.
    The installation completion screen listing the result for each feature

Set up SQL Server 2022 Express with Advanced Services

  1. Click the Start button, and launch "Microsoft SQL Server 2022" - "SQL Server 2022 Configuration Manager".
  2. In the left pane, select "SQL Server Network Configuration" - "MSSQLSERVER Protocols". Then, right-click "TCP/IP" in the right pane and click "Enable (E)".
    SQL Server 2022 Configuration Manager, right-clicking "TCP/IP" to choose "Enable (E)"
  3. In the left pane, select "SQL Server Services". Then, in the right pane, select "SQL Server (MSSQLSERVER)" and click "Restart (T)".
    SQL Server 2022 Configuration Manager, right-clicking "SQL Server (MSSQLSERVER)" to choose "Restart (T)"
  4. When the restart is complete, this procedure is complete.