28,661 questions
We are unable to install SQL Server 2019 Express / Standard with same environment.
Kindly help us urgently.
SSD showing incorrect bytes per sector Win 11 - SQL server 2017 installation cannot be completed
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 90%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DR
46
Reputation points
Hello,
I recently purchased a new HP Envy laptop with Win 11 pre-installed.
It works great so far, when it comes to streaming, usuing the internet, MS office and Adobe applications.
However, when I tried to install DATEV (a German accounting program, which also installes the SQL server 2017) an error occured and the installation of the SQL server was cancelled. The DATEV support checked my machine and advised me that this seems to be an issue related to Win 11 and is impacting the Samsung SSD that HP used for these models.
They ran a test, which delivered the following results:
C:\windows\system32>fsutil fsinfo sectorinfo c:
Logische Bytes pro Sektor: 512
Physische Bytes pro Sektor für Unteilbarkeit: 32768
Physische Bytes pro Sektor für Leistung: 32768
Effekt. phys. Bytes/Sektor für Unteilbark. in Dateisystem:4096
Geräteausrichtung: Ausgerichtet (0x000)
Partitionsausrichtung auf Gerät: Ausgerichtet (0x000)
Kein Abzug für Suchen
Kürzen wird unterstützt
Nicht DAX-fähig
Nicht mit schlanker Speicherzuweisung bereitgestellt
I was told that the SSD should not return the two results of 32768, but is rather expected to return a result of 4096, or below.
Online, I found information that the new Win 11 seems to slow down many SSD drives and that some of them are working about 45% slower than under Win 10. Supposedly, this was fixed with an update. I installed all current updates (see screenshot below), but nothing helped.
Is there anything I can do, in order to fix this issue? Or do I have to wait for another Win patch to be released?
Thank you for your feedback.
Windows for business | Windows Client for IT Pros | User experience | Other
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 37%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sudipta Ghosh 1 Reputation point2022-01-10T11:47:07.3+00:00 I am unable to install SQL Server 2019 (Express or Standard) in the following scenario:
- MacBook Pro / 2021 Model
- Windows 11 Pro (downloaded the ARM based not x86, which is the right version for my Macbook Pro M1
- Microsoft Website clearly says that SQL Server 2019 is compatible with Windows 11 (RTM) – so we should safely rule out the issues of Windows 11 pre-release version incompatibility
- The net result is that I have no option but to somehow get SQL Server 2019 to be successfully installed on Windows 11 in the above environment
Please help to solve this issue.
Sign in to comment
6 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 40%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
saikat das 6 Reputation points2022-01-10T09:15:32.31+00:00 -
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2022-01-10T22:56:44.33+00:00 Kindly help us urgently.
I think what you first need help with is how to ask question in these forums. You post a new question, and you include information that is pertinent for the question. For an installation problem, you should supply the files summary,txt and detail.txt,
But posting a few lines to an existing thread will take you nowhere. And adding "urgently" only puts people off. People here answer questions in their free time, and you will have to accept that you will have to wait a while.
Sign in to comment -