How to Install SQL Server on Windows 11

To set up a free local SQL Server database on Windows 11, download SQL Server 2025 Express from Microsoft, install it, add SQL Server Management Studio (SSMS) separately, then connect to your instance and run one test query.

A quick note on names: SQL is the query language, SQL Server is Microsoft’s database product, and MySQL or PostgreSQL are separate products with their own installers.

Pick the Right Free Edition

SQL Server 2025 is the current release, and Microsoft’s SQL Server downloads page offers two free choices. Here is how they compare for a Windows 11 PC.

Edition	Allowed use	Good fit
Express	Free for development and production use in small desktop, web and server apps	Learning, class work, a small app’s database
Standard Developer	Free, licensed for development and testing only	Testing features that Express lacks, such as SQL Server Agent jobs
Enterprise Developer	Free, licensed for development and testing only	Server-class testing; Microsoft’s requirements table marks Enterprise as not supported on Windows 11 and doesn’t list the Developer editions separately, so check the requirements before trying it on Windows 11
LocalDB	A lightweight mode included with the Express download	Developers who only need a database that starts on demand inside their own tools

Express has limits worth knowing before you start. According to Microsoft’s SQL Server 2025 editions page, it uses the lesser of one socket or four cores, caps the buffer pool at 1,410 MB per instance, and allows relational databases up to 50 GB. SQL Server Agent isn’t included. In SQL Server 2025, the old “Express with Advanced Services” download was folded into Express, and the Web edition was discontinued. If an older guide mentions either, that is why you won’t find it.

Check That Windows 11 Meets the Requirements

Microsoft’s SQL Server 2025 hardware and software requirements list Windows 11 Home, Pro, Enterprise and IoT Enterprise as supported for Express and Standard. Home is fine for Express, with no feature cut described by Microsoft.

Item	Microsoft’s requirement
Processor	x64, 1.4 GHz minimum (2.0 GHz or faster recommended)
Memory (Express)	512 MB minimum, 1 GB recommended
Memory (other editions)	1 GB minimum, 4 GB or more recommended
Disk	At least 6 GB free; setup also needs about 6 GB free on the system drive for temporary files
.NET Framework	4.7.2 or later

The disk figure depends on what you install. Microsoft lists about 1,480 MB for the Database Engine with replication and full-text search, and about 8 GB for every feature, so a beginner install that sticks to the Database Engine stays near the low end. SSMS needs its own space (covered below).

Install SQL Server 2025 Express

You need an administrator account, because setup installs Windows services. If Windows blocks the installer, see how to run a program as administrator in Windows 11.

1. Open the SQL Server downloads page and choose the free download under SQL Server 2025 Express. Only download it from Microsoft.
2. Open the small file that lands in your Downloads folder. It is a launcher that fetches the rest of SQL Server.
3. Choose an installation type. At the time of writing, the launcher offers a quick install with default settings, a custom install that lets you pick each option, and an option to download the full installation media for later. The exact labels can change, so read each one before you click.

4. For a first install, the quick option is the simplest. Accept the license terms, keep the suggested install location unless your system drive is short on space, and let it run.
5. When it finishes, note the instance name and, if the final screen shows one, the connection string. An Express instance is normally named SQLEXPRESS.
6. Restart the PC if setup asks you to.

Use the Custom Install for More Control

Choose the custom route when you want a different instance name, Mixed Mode sign-in, or to skip optional components. It opens the full setup wizard that Microsoft documents in Install SQL Server from the Installation Wizard. The key pages:

1. In SQL Server Installation Center, select Installation, then New SQL Server standalone installation or add features to an existing installation.
2. On License Terms, accept the terms and select Next.
3. On Azure Extension for SQL Server, the option is selected by default. Clear it if you won’t connect this PC to Azure.
4. On Feature Selection, keep Database Engine Services. Leave extra features off unless a course or app asks for them.
5. On Instance Configuration, choose a named instance (SQLEXPRESS is a sensible name) or a default instance, which is called MSSQLSERVER. You can have only one default instance per PC.
6. On Server Configuration, keep the default service accounts and collation unless you have a reason to change them.
7. On Database Engine Configuration, pick Windows Authentication or Mixed Mode, then select Add Current User so your account becomes a SQL Server administrator.

8. On Ready to Install, select Install. Restart if prompted.

Which sign-in mode? Windows Authentication lets you sign in with your Windows account and no extra password, and Microsoft recommends it where possible. Pick Mixed Mode only if an app needs a SQL Server login and password. Mixed Mode requires a strong password for the built-in sa account, so store it somewhere safe before you click Next.

Install SQL Server Management Studio

SQL Server setup doesn’t include a graphical tool for writing queries. SSMS is a separate free download, and the current major version is SSMS 22. Microsoft’s SSMS install instructions describe these steps:

1. Download the SSMS 22 installer from Microsoft. The file is a small bootstrapper named vs_SSMS.exe.
2. Double-click it in your Downloads folder. The Visual Studio Installer opens, because SSMS 22 now installs through it (there is no standalone MSI).
3. Optionally pick extra workloads or individual components, then select Install.
4. When it finishes, open SQL Server Management Studio from the Start menu.

Microsoft’s SSMS requirements call for at least 4 GB of RAM (16 GB recommended) and between 4 GB and 50 GB of disk space depending on what you add. SSMS 22 also runs on Windows 11 on Arm.

Connect and Run Your First Query

1. In SSMS, the Connect to Server dialog usually opens on its own. If it doesn’t, select Connect in Object Explorer.
2. If the dialog shows a Server type box, choose Database Engine.
3. For Server name, type your computer name, a backslash and the instance name, for example PRIYA-LAPTOP\SQLEXPRESS. localhost\SQLEXPRESS also works on the same PC. For a default instance, the computer name alone is enough.
4. Choose Windows Authentication and select Connect.

5. Select New Query, type SELECT @@VERSION; and press F5. A result row with the SQL Server version and edition means the install works.

Worked example: Priya is setting up a database for a class project. After connecting, she runs CREATE DATABASE BookClub;, refreshes the Databases folder in Object Explorer, and sees BookClub listed. Her course scripts can now create tables inside it.

Prefer the command line? If the sqlcmd tool is installed, open Command Prompt and run sqlcmd -S .\SQLEXPRESS -E -C -Q "SELECT @@VERSION". The sqlcmd utility page explains each switch: -S names the server, -E uses Windows Authentication, -Q runs one query and exits, and -C trusts the self-signed certificate on a local test instance (newer sqlcmd versions encrypt connections by default, so leave -C off for servers on a network).

Confirm the SQL Server Service Is Running

SQL Server runs as a Windows service, and you manage it with SQL Server Configuration Manager.

1. Open Start, type SQLServerManager17.msc (the file name for SQL Server 2025) and press Enter. Microsoft notes the file lives in C:\Windows\SysWOW64.
2. Select SQL Server Services.
3. Find SQL Server (SQLEXPRESS), or the name of your instance, and check that its state is Running. If it isn’t, right-click it and choose Start.

Microsoft recommends Configuration Manager over the general Services console for changing SQL Server service accounts. To just glance at the service, the Services tool in Windows Tools works too.

Turn On TCP/IP Only If Another App or PC Needs It

On a new Express or Developer install, Microsoft’s default network protocol table shows Shared Memory enabled and TCP/IP disabled. SSMS on the same PC connects through Shared Memory, so for local learning you can leave everything as it is. Turn TCP/IP on when an app that uses a TCP connection string, a container, or another computer has to reach the database.

1. In SQL Server Configuration Manager, expand SQL Server Network Configuration and select Protocols for SQLEXPRESS.
2. Right-click TCP/IP and choose Enable.
3. Under SQL Server Services, restart SQL Server (SQLEXPRESS). For a named instance such as Express, Microsoft also says to restart the SQL Server Browser service.

You need a firewall rule when another computer has to connect. Microsoft’s firewall guidance for SQL Server says a default instance listens on TCP port 1433, named instances use dynamic ports unless you set a fixed one, and SQL Server Browser uses UDP port 1434. Open just the port you need instead of turning the firewall off; the section on allowing a single inbound port in this Windows 11 firewall walkthrough shows how.

Fixes When Setup or the Connection Fails

• Setup stops on a disk or rules check: free at least 6 GB on the system drive, even if you install SQL Server to another drive, then run setup again.
• Setup asks for a restart: restart before you rerun it, since setup checks may stop while a restart is pending.
• “Cannot connect” to localhost\SQLEXPRESS: confirm the instance name in Configuration Manager, check that the service is running, and make sure you typed a backslash, not a forward slash.
• A certificate or trust error in SSMS: SSMS sets Encryption to Mandatory by default, and a fresh local install uses a self-signed certificate. The connection dialog has a Trust server certificate check box; turn it on only for a local test instance you control, not for a server on a network.
• An app can connect by name but not by IP address and port: TCP/IP is probably still disabled. Enable it as shown above.
• Login failed for a SQL login: the instance may be using Windows Authentication only. Sign in with Windows Authentication, or rerun setup and choose Mixed Mode.

Other Ways to Run SQL Server on Your PC

LocalDB is a lightweight mode of Express that starts on demand. Microsoft’s LocalDB page says it comes with the SQL Server 2025 Express download and that you connect to (localdb)\MSSQLLocalDB. It suits developers whose tools manage the database for them.

Containers: Microsoft publishes a SQL Server 2025 container image, but its quickstart lists Linux hosts as the supported platform, so a container is not the beginner path on Windows 11. Azure SQL Edge, which some older guides suggest for containers, was retired on September 30, 2025.

SQL Server Install Questions

Can I Use SQL Server Express for a Real App?

Yes. Microsoft describes Express as free for development and production use in small apps. The Developer editions are the ones limited to development and testing. If your data grows past the 50 GB per-database cap, plan a move to a paid edition, which Microsoft says Express can be upgraded to.

Is SSMS the Same Thing as SQL Server?

No. SQL Server is the database engine that stores your data and runs as a service. SSMS is the program you use to connect to it, browse databases and write queries. Removing or updating SSMS doesn’t touch your databases.

Can I Install More Than One Instance?

Yes. One PC can hold one default instance and several named instances, each with its own services. That is useful when a class needs a clean instance separate from your project work, but each instance uses its own memory and disk.

Does SQL Server Install the Sample Databases?

No. Microsoft says sample databases and sample code aren’t installed by SQL Server Setup by default. Create your own test database, as in the example above, or download the samples your course names.

With the engine running and SSMS connected, a good next step is pairing it with a language for data work; if you plan to use Python, see how to install Python on Windows 11.