Frustrating with error message every time while installing MS SQL server 2022

Sachin Gurung 20 Reputation points
2025-01-17T12:32:34.5833333+00:00

I am trying to install MS SQL server 2022. I am getting this every time when i reinstall and install again even in my brand-new laptop I never experienced before this while installing SQL. Please can anyone advise me to fix this. Please see the error message User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,472 questions
{count} votes

Accepted answer
  1. Bruce (SqlWork.com) 71,506 Reputation points
    2025-01-17T16:48:00.1466667+00:00

    you don't show the error messages, hardware or O/S. but there are two common

    windows 11 disk sector size too large:

    https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size

    sqlserver does not support arm64 hardware.


1 additional answer

Sort by: Most helpful
  1. Erland Sommarskog 116.8K Reputation points MVP
    2025-01-17T21:54:41.9133333+00:00

    First things first: what hardware do you have? If you have an ARM processor, beware that SQL Server does not support ARM. The rest of the answer assumes that you have a regular x64 processor.

    My belief is that this is an error that occurs mainly in the situation when a user tried to install SQL Server and it failed with some error. The user might have tried some random cleanup and made renewed attempts. Because the cleanup was incomplete, Setup now fails with another error than it did originally.

    Could this apply to you? Or did this happen on the first attempt? (If it does apply to you, don't feel bad. I think it is quite a natural path to take.)

    Here is a link to an article that can help you to clean up properly: https://www.sql-easy.com/learn/how-to-uninstall-sql-server/. I have not tried it myself, but I learnt about it from a user who was in a similar situation as yours, and who was able to install SQL Server successfully after following the article.

    If you are on Windows 11, be sure to read the article Troubleshoot errors related to system disk sector size greater than 4 KB before you try again. It discusses a known issue where Windows 11 reports a disk-sector size that SQL Server chokes on. This could be the cause for your original failure. Check out this article, and if needed apply the workarounds it proposes.

    If you make a new attempt after cleanup, and it still fails, you find log files in C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log with one folder per attempt. (nnn is a three-digit number that depends on the version of SQL Server you are trying to install). The files of most interest are summary.txt, detail.txt and any file with ERRORLOG in the name. (The latter only appears if Setup came as far as trying to start SQL Server). Feel free to attach these to the thread here.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.