Hello,
I'm currently working on getting our SQL Server Express database working with BitLocker but I am coming across a few problems. Here is my scenario:
The OS is partitioned into two volumes (C and D).The C volume contains the OS and Software, while the D volume is primarily used for the database files (logs, back, and mdf).The D volume is encrypted using BitLockerThe database connects using the SA account (SQL Server Authentication)
From what I understand, BitLocker must be enabled with the same account that the SQL Server is running on. So what I have done is change the SQL Server service account to the user account (lets say its called User) via SQL Configuration Manager. While staying
logged into User account, I then enable BitLocker via Control Panel -> System and Security -> BitLocker Drive Encryption. I then reboot and then while the software is trying to connect to the database I get the following &nb ...
Go to the complete details ...