Callback
  • From a market stall to a store

  • -

  • From a store to a retail chain

  • -

  • From retail to manufacturing

Installing SQL Server on Windows 11: Common Errors and Solutions

Volodymyr Vytyshchenko
Volodymyr Vytyshchenko

Trade automation expert at Torgsoft

Installing SQL Server on Windows 11 often ends with errors due to changed security mechanisms, TLS, PowerShell, and disk handling. This article helps you work through common installation errors: what you see, why it happens, and what to do so that SQL Server installs successfully.

This material is intended for users and system administrators who have basic skills in working with the operating system, Windows services, and Microsoft SQL Server. All described actions are performed at your own risk: incorrect changes to settings, services, or the database may lead to data loss or program inoperability. Before making changes, it is recommended to create an up-to-date backup of the database, check free disk space, and make sure there are no active users in the system. If you are not confident in the correctness of your actions or do not understand the consequences — you should contact technical support.

When this is relevant

  • Installing or updating SQL Server on Windows 11, including version 22H2 and newer.

  • Migrating Torgsoft to a computer with Windows 11 installed.

  • Attempting to use an outdated version of SQL Server (2012/2014).

How to understand that the problem is specifically with SQL installation

  • The SQL installer does not start or freezes.

  • A PowerShell V2 error during installation.

  • The SQL Server service starts and immediately stops.

  • The “Wait on the Database Engine recovery handle failed” error.

  • It is impossible to connect from other PCs (“SQL Server does not exist”).

  • Encoding problems (???? instead of Cyrillic).

Main causes of errors on Windows 11

  1. Incompatibility of old SQL versions with Windows 11 (PowerShell V2, TLS 1.2).

  2. Disk issues (NVMe / 4K sector size).

  3. Missing system components (.NET Framework).

  4. Incorrect SQL service permissions.

  5. Ports blocked by the firewall.

  6. Incorrect encoding (Collation).

What to do: common errors and fixes

A. PowerShell V2 error (often for SQL 2014)

Issue. Windows 11 does not support PowerShell V2.
Actions:

  1. Install SQL Server 2019 or 2022 (recommended).

  2. If SQL 2014 is critically required — perform a manual installation after enabling .NET Framework 3.5.

  3. Restart the PC after the changes.

B. Disk sector size error (NVMe / 24H2)

Issue: outdated versions of SQL Server do not support disks with a sector size greater than 4096 bytes.
Actions: run the command through Start → cmd as administrator:

reg add "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f

After execution — restart the PC.

C. Problems with .NET Framework

Issue: components are missing or blocked by policies.
Actions:

  1. Enable .NET Framework 3.5 through Start → optionalfeatures → Windows Features/

  2. If .NET Framework 3.5 does not enable and error 0x800F0950 appears — this is an atypical situation that is better resolved with a technical specialist.

  3. For SQL 2019/2022, check for .NET 4.5.2+.

D. Windows 11 24H2 — compatibility errors

Issue: enhanced security mechanisms block outdated installers.
Actions:

  • Use SQL Server 2022.

  • Avoid SQL 2012/2014 on new Windows 11 builds.

E. The “Wait on the Database Engine recovery handle failed” error

Issue: the SQL service does not have sufficient permissions for the first start.
Actions:

  • During installation → Server Configuration
    change the service account to Local System (NT AUTHORITY\SYSTEM).

F. TLS 1.2 issues (SQL 2012/2014)

Issue. Windows 11 requires TLS 1.2, and old SQL versions do not support it “out of the box”.
Actions:

  • Install SQL only with Service Pack (SP3+).

  • Or switch to SQL 2019/2022.

G. Incorrect encoding (Collation)

Issue: incompatible encoding is inserted automatically.
Actions:

  • During installation, explicitly select Cyrillic_General_CI_AS.

H. Blocking of ports 1433 / 1434

Issue. Network connection to SQL Server is blocked due to firewall settings and SQL Server instance configuration.

Explanation. For operation from other computers, it is not enough just to open ports in the firewall. The following conditions must be met at the same time:

  • a SQL Server instance must be used and configured correctly,

  • the network protocol for this instance must be enabled,

  • a static port must be assigned,

  • that same port must be allowed in Windows Firewall.

Actions:
Configuring network access to SQL Server is a complex operation that includes:

  • working with SQL Server Configuration Manager,

  • enabling protocols for the required instance,

  • assigning a static port,

  • creating the corresponding rules in Windows Firewall.

For an unprepared user, these steps may be difficult and may lead to additional errors, so in such cases it is recommended to contact a technical specialist.

How to verify that SQL has been installed and is working

  1. Check through Start → services.msc that the SQL Server and SQL Server Browser services have the status «Running».

  2. Connection through SQL Server Management Studio under the sa user — without errors.

  3. Torgsoft starts without database connection errors.

Prevention

  • Do not use Cyrillic characters in the PC name and paths.

  • Have 10–20 GB of free space on drive C:.

  • Disable third-party antivirus software during installation.

  • Always update Windows before installing SQL.

  • For Windows 11, choose SQL Server 2019/2022.

Summary

  • Windows 11 → SQL 2022 — the default standard.

  • SQL 2014 on Win 11 — only in exceptional cases and with manual fixes.

  • If you have an NVMe SSD — be sure to check the disk sector size.

Програма обліку товару | Торгсофт



Facebook Instagram YouTube Twitter Google News Apple Podcast SounCloud

Add comment

Add comment
Thank you for your feedback! It will be published after being reviewed by a moderator.
Related articles