I was told that this forum may be able to help me with my issues (see original thread here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8c81fde1-e91b-46eb-8d2f-b79426805ddd/using-sql-server-2012-express-with-bitocker?forum=sqlexpress).

Background:

To summarize, I have an OS that is partitioned into two volumes: C and D.

C drive contains the running software, SQL Server install, and the OS.

D drive is the encrypted partition via BitLocker. The SQL Server files are stored here (logs, backup, and mdf).

Problem:

The software cannot connect to the database stored on the encrypted D volume when BitLocker is turned on. The user account that I use to enable BitLocker is the same SQL Server Service account and has is also part of the Local Admin Group. As soon as I disable BitLocker, the software works fine and the database connection succeeds. I am currently using the SQL System Admin account to login (SA) and BitLocker is being used with a TPM.

The error I am experiencing when connecting through the software is 'login failed for user sa'.

Thank you for the suggestions/help.

• Moved by Brandon RecordsModerator Tuesday, May 05, 2015 3:52 PM Moved to more appropriate forum.

moncadad,

Well if you have MBAM configured, then it should be more easier to make it work, as we have guides here:

How to Verify BitLocker Recovery Keys in SQL DB using MBAM

If you need the SQL service Account to access the locked drive, then the account should be the one which to enable Bitlocker and initialize the TPM.

1. On computers that have a TPM, initialize the TPM by using the TPM Initialization Wizard, the BitLocker Drive Encryption item in Control Panel, or by running a script designed to initialize it.

2.  Set up BitLocker. Access the BitLocker setup wizard from the Control Panel, which guides you through setup and presents advanced authentication options.

For the logon failure information, would you mind share a screenshot or telling us the full error message here?

R