Using SQL Server with BitLocker - The operating system returned error 21 (The device is not ready.) to SQL Server during a read at offset….




When using Microsoft SQL Server on a computer protected by BitLocker you may see the error

The operating system returned error 21 (The device is not ready.) to SQL Server during a read at offset….




This error can be caused because BitLocker auto-unlocks the drive after SQL Server has already started.


You can either set the service to manual and start it after login (manually or with a login script) or try using the Automatic (Delayed Start) startup type on the SQL service.






Comments

Popular posts from this blog

SOLVED: Exchange Online Management PowerShell Connect-ExchangeOnline bug "A window handle must be configured. See https://aka.ms/msal-net-wam#parent-window-handles"

Windows Server 2016, 2019, 2022, Windows 10 and Windows 11: Date and time "Some settings are managed by your organization".

TFTPD32 or TFTPD64 reports Bind error 10013 An attempt was made to access a socket in a way forbidden by its access permissions.