We're trying to use Bitlocker to secure an SQL Server 2012 database. We don't have any issue getting bitlocker to work… the issue we have is that once the drive is locked, SQL Server can no longer read the data.
We'd love to use TDE, obviously, but since that's limited to the Enterprise edition, that's a no-go. We have TPM activated on the server. This is in a Windows Domain and we use Windows Authentication… but once the drive is encrypted, we cannot access the DB with anything.
What am I missing here?
Best Answer
You need to use the account that the SQL Server runs as to enable Bitlocker.