User Manual

01.19.2026

MANUAL

Install and Configure SQL Server 2025 Express

## Limitations SQL Server 2025 Express Edition is limited to a maximum database size of 50 GB. If you want to use more than 50GB, you need to migrate to a higher edition or Microsoft Azure SQL Database. For more information about SQL Server 2025 Express Edition limitations, please refer to the following page. [Teach me about the limitations of SQL Server Express.](faq-sql-server-express-restriction) ## Downloading SQL Server 2025 Express Edition 1. Access the following URL and click the "Download Now" link for "SQL Server 2025 Express". https://www.microsoft.com/ja-jp/sql-server/sql-server-downloads ![image](https://pleasanter.org/binaries/abc2a3cb66084217b1a3374e22505f42) 1. Double-click the downloaded file. ![image](https://pleasanter.org/binaries/1e4a885e4c6a41ea8bd932de41742883) 1. If "User Account Control" appears, click the "Yes" button. ![image](https://pleasanter.org/binaries/0ee3c75a12ee4e2aab8051f294b5a47a) 1. Click "Download Media". ![image](https://pleasanter.org/binaries/3599f9232c9b44e59f4e7b753b1ccbc1) 1. Select "English", check "Express Core (714 MB)", and click the "Download" button. ![image](https://pleasanter.org/binaries/9ec478fcbdc54a7b9b5f49884879ae40) 1. Wait until the download is complete. ![image](https://pleasanter.org/binaries/d1b8c36f88f04e138127093e9543b12c) 1. When "Download successful!" is displayed, click the "Open folder" button. ![image](https://pleasanter.org/binaries/a5aed990e092487aac6702332d8359f1) ## Installing SQL Server 2025 Express Edition 1. Double-click "SQLEXPR_x64_JPN". ![image](https://pleasanter.org/binaries/70b732c13637451891e5facc06c22bc0) 1. If "User Account Control" appears, click the "Yes" button. ![image](https://pleasanter.org/binaries/a0eaf14e70b54fb2aef8f7bb10ba3ab4) 1. When the "Select directory for extracted files" dialog appears, click the "OK" button. ![image](https://pleasanter.org/binaries/fc9ac7b9a59549559c2f877b65dd7984) 1. Wait until the extraction preparation is complete. ![image](https://pleasanter.org/binaries/dce6d948c2da46158fead3d2a60bad5d) 1. Click "New SQL Server standalone installation or add features to an existing installation". ![image](https://pleasanter.org/binaries/707a64c892a64de4948d046d9973e0db) 1. Check "I accept the license terms and Privacy Statement", then click the "Next" button. ![image](https://pleasanter.org/binaries/44da86c7b5634f1ca2b1cfb6a010c021) 1. The "Global Rules" screen will be skipped. If it is not skipped, follow the on-screen instructions. ![image](https://pleasanter.org/binaries/5699bd16c5fd450d964e894f8581e900) 1. Check "Use Microsoft Update to check for updates (recommended)", then click the "Next" button. ![image](https://pleasanter.org/binaries/62d31dcacc2847eaaafdcb167f4fdeb1) 1. On the "Install Rules" screen, click "Next". ![image](https://pleasanter.org/binaries/7b2f696bcba145778cddf31e1ea84810) 1. Check only "Database Engine Services" and "Full-Text and Semantic Extractions for Search", then click the "Next" button. ![image](https://pleasanter.org/binaries/891aad4311cf4429b1b67494959598ff) 1. Check "Default instance" and click the "Next" button. ![image](https://pleasanter.org/binaries/c4c9699435c14a9d8377cbff0df37d0b) 1. Click the "Next" button. ![image](https://pleasanter.org/binaries/25c81df39ea843718864b575f54d72bf) 1. Check "Mixed Mode (SQL Server authentication and Windows authentication)" and set any password. Please note the password you set, as it will be used during [Pleasanter installation](/manual/getting-started-installer-pleasanter-windows). Then click the "Next" button. The installation will begin. ![image](https://pleasanter.org/binaries/742a314cdbc14c3c894cdef97b0fe408) 1. Wait until the installation is complete. ![image](https://pleasanter.org/binaries/bdb80a9b2ec04b96b11e6ac5dc53aa1f) 1. Confirm that the installation was successful and click the "Close" button. ![image](https://pleasanter.org/binaries/4040751cae0046edb9c67a576a3b979b) ## Configuring SQL Server 2025 Express Edition 1. Click the "Start" button, then launch "All" - "Microsoft SQL Server 2025" - "SQL Server 2025 Configuration Manager". 1. If "User Account Control" appears, click the "Yes" button. 1. In the left pane, click "SQL Server Network Configuration" - "Protocols for MSSQLSERVER". Then, in the right pane, right-click "TCP/IP" and click "Enable". ![image](https://pleasanter.org/binaries/f659977953704aeeb8afb30c6132d142) 1. If a warning appears, click the "OK" button. ![image](https://pleasanter.org/binaries/c5cf017b210a48eb810ece5320c62fb4) 1. In the left pane, click "SQL Server Services". Then, in the right pane, right-click "SQL Server (MSSQLSERVER)" and click "Restart". ![image](https://pleasanter.org/binaries/82159142c4a24c228855e7a8b7130742) 1. Once the restart is complete, this procedure is finished.
TOP