Forum Discussion

Max12's avatar
Max12
Copper Contributor
Apr 03, 2026

Unable to install SQL Server 2022 Express (installer glitch + SSMS error)

Hi, I recently purchased a new Lenovo laptop, and I am trying to install Microsoft SQL Server 2022 Express along with SSMS. SSMS installed successfully, but SQL Server installation fails, and someti...
Installation
sql
sql server
sql-server-2022
ssms
Jamony's avatar
Jamony
MCT
Jul 18, 2026

SSMS is only the client; it does not install the Database Engine. Error 40 is expected if Express setup failed or no instance is running. Run the SQL Server 2022 Express installer as administrator, choose Basic or Custom, and confirm Database Engine Services completes. Express normally creates the named instance SQLEXPRESS.

After setup, open SQL Server Configuration Manager or Services and confirm SQL Server (SQLEXPRESS) is running. In SSMS, connect locally with .\SQLEXPRESS or (local)\SQLEXPRESS using Windows Authentication. SQL Server Browser and TCP/IP are unnecessary for that local test; enable them only when remote access requires them, then configure the firewall.

If installation fails, stop reinstalling SSMS. In the SQL Server Setup Bootstrap Log folder, inspect Summary.txt, then Detail.txt and the component log named in the failure. The error code and failed feature identify the cause. Check for a supported Windows build, a pending restart, disk space, and permissions.