1

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???

1

1 Answer 1

0

If somebody have the same problem: Open Services and change Startup type from "Automatic" to "Automatic (Delayed Start)" and be happy. And one more... you should delete password for bitlocker on drive D

1
  • Tried that already thanks but it didn't work. Strangely, Win 11 on the exact same box doesn't suffer the same issue.
    – EvilDr
    Commented Aug 30, 2023 at 10:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.