Vault Server Installation Issue (Hard Drive Sector Size)

I had a colleague who couldn't install the Vault server on their computer. When trying to start the SQL Server (AUTODESKVAULT) service, error 1067 occurred (the process terminated immediately).

In the event log, there was notably:

There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf.

I initially thought it was a permission issue or a corruption of the master.mdf database, but it turned out to be a hard drive problem. It was a new machine equipped with an NVMe drive that uses sector sizes greater than 4096 bytes, which is not compatible with SQL Server.

You can check this with the following command:

fsutil fsinfo sectorinfo C:

This should display the PhysicalBytesPerSectorForAtomicity and PhysicalBytesPerSectorForPerformance values, which should not exceed 4096.

On the machine in question, PhysicalBytesPerSectorForPerformance was set to 32768.

The fix involves creating a registry key and restarting. You can find more details here: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size

---

Besoin d'un développement Vault ? Contactez-moi pour un devis gratuit.