How to Install SQL Server Step by Step

Here is how to install SQL Server on Windows in short: check the requirements, run setup.exe from your installation media, choose New SQL Server standalone installation, enter your product key or pick a free edition, select the Database Engine, set the authentication mode and an administrator, then install. Finish by adding SQL Server Management Studio (SSMS) and the latest security update. Expect about 30–45 minutes.

Which SQL Server Edition Should You Install?

Install the edition that matches how the database will be used: Express or Developer for learning and testing, Standard for most small and mid-sized production workloads, and Enterprise for large, high-availability systems. This table covers the two current versions.

SQL Server 2025 became generally available on 18 November 2025. SQL Server 2022 remains fully supported, with mainstream support to 12 January 2028 and extended support to 12 January 2033, according to Microsoft's SQL Server 2022 lifecycle page. On a Windows 10 or 11 PC, only Standard, Developer and Express are supported; Enterprise needs Windows Server.

What Are the System Requirements for SQL Server?

SQL Server 2022 and 2025 need a 64-bit (x64) processor of at least 1.4 GHz, at least 1 GB of RAM (512 MB for Express), 6 GB of free disk space and .NET Framework 4.7.2. Microsoft recommends 2.0 GHz or faster and at least 4 GB of RAM for anything beyond testing.

The 6 GB applies to the system drive even if you install SQL Server to another drive, because setup unpacks temporary files there. Note that SQL Server 2025 drops support for Windows Server 2016, so an older host needs upgrading first. Our Windows 10 end of life guide explains why a supported OS matters for a database machine too.

How Do You Prepare Before Installing SQL Server?

Preparation means confirming the Windows version, installing pending Windows updates and deciding a few settings in advance. Five minutes of planning here avoids reinstalling later.

• Update Windows and restart. Pending restarts are a common reason setup rules fail.
• Choose an instance name. A default instance is reached by the computer name; a named instance by COMPUTERNAME\INSTANCENAME. Use a default instance unless you need several on one server.
• Decide on authentication. Windows Authentication is more secure. Mixed Mode adds SQL logins such as sa, which some third-party applications require.
• Plan data drives. On a server, put data, log and TempDB files on separate drives from Windows where possible.
• Have your licence ready. For Standard or Enterprise, keep the product key and installation media to hand.

How to Install SQL Server Step by Step

These steps follow the SQL Server 2022 setup wizard; SQL Server 2025 uses the same sequence. Microsoft's installation wizard documentation describes every page in detail.

1. Mount the ISO or open the installation folder, right-click setup.exe and choose Run as administrator.
2. In SQL Server Installation Center, select Installation → New SQL Server standalone installation or add features to an existing installation.
3. On the Edition page, either choose a free edition (Developer, Express or Evaluation) or select Enter the product key and type your Standard or Enterprise key. Select Next.
4. Accept the License Terms. Let Global Rules run, then decide whether to use Microsoft Update to receive SQL Server updates (recommended).
5. Wait for Install Setup Files and Install Rules. Fix any rule marked Failed; a Windows Firewall warning is normal and simply reminds you to open a port later.
6. On Azure Extension for SQL Server, clear the checkbox unless you want to connect this server to Azure Arc.
7. On Feature Selection, tick Database Engine Services. Add Full-Text Search only if your application needs it. Confirm the instance root directory.
8. On Instance Configuration, choose Default instance or enter a named instance.
9. On Server Configuration, keep the default service accounts unless your organisation uses dedicated ones. Set SQL Server Agent to Automatic if you plan to schedule backups. Check the Collation tab if your application specifies one.
10. On Database Engine Configuration, choose Windows authentication mode or Mixed Mode (set a strong sa password), then select Add Current User to make yourself an administrator. Review the Data Directories and TempDB tabs.
11. Review the summary on Ready to Install, select Install, and wait for Complete. Restart if prompted.

How Do You Install SQL Server Management Studio?

SSMS is a separate download, not part of SQL Server setup. The current version, SSMS 22, installs through the Visual Studio Installer.

1. Download the SSMS 22 installer from Microsoft's SSMS installation page. It downloads a small file named vs_SSMS.exe.
2. Run it. Visual Studio Installer opens and installs SSMS.
3. Open SSMS, enter your server name (for example localhost or .\SQLEXPRESS for a default Express install), choose the authentication you configured, and select Connect.
4. Expand Databases in Object Explorer to confirm the instance is working.

What Should You Do After Installing SQL Server?

After installation, patch the server, open network access only if needed and set up backups. A new install is functional, but not yet production-ready.

• Install the latest update. Microsoft fixes SQL Server vulnerabilities through regular security updates; in November 2025, for example, it patched an elevation-of-privilege flaw (CVE-2025-59499) in supported versions, including SQL Server 2022. Installation media is often older than the latest fix, so check for updates straight away.
• Allow remote connections only if required. Open SQL Server Configuration Manager → SQL Server Network Configuration, enable TCP/IP, restart the service and allow the port (1433 for a default instance) in Windows Firewall.
• Schedule backups with SQL Server Agent maintenance plans or your backup software. Express has no Agent, so use Windows Task Scheduler instead.
• Cap maximum server memory under the server's Properties → Memory so Windows keeps enough RAM for itself.

A Common Mistake We See

The mistake we see most often is installing Developer or Evaluation edition "just to get started" and then putting real business data on it. Developer is licensed for development and testing only, and Evaluation expires. Both cause trouble later: one is a licensing problem, the other a database that suddenly stops starting.

Decide on the edition before you load live data. If you outgrow Express or need a production server, a genuine SQL Server 2022 Standard key can be entered on the Edition page during setup. SQL Server needs a supported host as well; the Windows Server range covers that side, and our Windows Server 2022 Standard install guide walks through setting one up. Every key we sell comes with a 30-day money-back guarantee and lifetime replacement warranty, and our support team can help with activation.

Frequently Asked Questions

How long does it take to install SQL Server?

A basic Database Engine installation usually takes 20–40 minutes on a modern PC or server, depending on disk speed and features selected. Allow extra time for Windows updates beforehand, SSMS afterwards, and the latest SQL Server security update, which can add another 15–30 minutes.

Can I install SQL Server on Windows 11?

Yes. SQL Server 2022 and 2025 support Windows 10 and Windows 11, including Home and Pro. On desktop Windows, only the Standard, Developer and Express editions are supported. Enterprise edition requires Windows Server 2019, 2022 or 2025 for SQL Server 2025.

Is SQL Server free to install?

Express and Developer editions are free. Express can run small production databases up to 50 GB per database in SQL Server 2025 (10 GB in 2022). Developer has full features but is licensed only for development and testing. Standard and Enterprise need a paid licence.

Should I install SQL Server 2022 or 2025?

Both are supported. SQL Server 2025 is the newest release, with larger Express and Standard limits, but it no longer supports Windows Server 2016 and removes some components such as Reporting Services. SQL Server 2022 is mature, widely supported by applications and supported until January 2033.

Does SQL Server setup install SSMS?

No. SQL Server Management Studio has been a separate download for several versions. Install SQL Server first, then download SSMS 22 from Microsoft, which installs through the Visual Studio Installer, and connect to your new instance.

Which authentication mode should I choose during SQL Server installation?

Choose Windows Authentication unless an application needs SQL logins. It uses your Windows or domain accounts and avoids storing separate passwords. If you pick Mixed Mode, set a strong sa password and consider disabling the sa login once you have created named administrator accounts.

Conclusion

Knowing how to install SQL Server properly comes down to choosing the right edition, checking the requirements and making a few clear decisions in the setup wizard, then patching and backing up straight away. For a production licence you can enter during setup, see our SQL Server collection.

Useful Links