Why does Bitlocker intermittently require SQL service restart after sleep?
1
vote
1
answer
667
views
I have a development machine that has two drives:
C:\ - Operating system (Win 10 Ent) and SQL Server 2012 Standard installation
D:\ - SQL Server databases, backups, logs
I recently activated BitLocker on both drives, then activated auto-unlock because I realised that SQL Server can't access the databases unless the drive is unlocked.
Now with SQL (and only SQL, all other services/programs are fine), on an **intermittent** basis I see the following behaviours occur:
1. After waking from sleep mode, and then starting SSMS, I cannot log in (login fails with invalid credentials error). This occurs for the Windows login account only
2. If login succeeds, or if I login using the **sa** account, then all databases are in the
Pending Restore
state
I guess both of these are due to the drive becoming locked during sleep (or perhaps not?)? After waking from sleep, if I restart the SQL Server service, and then restart SSMS, everything works fine.
I wondered what might cause this to be intermittent please, or if my assumptions are wrong, what is actually causing this?
*PS. Perhaps a BitLocker tag might be useful, as I see there are plenty of other questions relating to this???*
Asked by EvilDr
(860 rep)
Jul 17, 2017, 08:13 AM
Last activity: May 29, 2025, 08:09 PM
Last activity: May 29, 2025, 08:09 PM