I'm renting an unmanaged dedicated (physical) server, running Windows Server (currently 2012 R2, but it can be changed to another version of the Standard edition). I have a custom Windows service that accesses a database. I'm running the Web edition of SQL Server, so I can't protect data at rest. I tried encrypting the C drive with BitLocker, but since the server doesn't have a TPM chip, and thus requires entry of a password before the OS loads, since I don't have KVM access, and since the server can't be accessed via Remote Desktop before the OS loads, I had to have the OS reloaded.
I'd be happy to create a D drive for the data, and encrypt that, but I want it so that when the server reboots, the Windows service starts running, and has access to the data on that D drive, without a person having to type a password. I think that would require some configuration that uses Windows authentication of the user which the Windows service runs under to access the D drive.
Is there some way to configure BitLocker to work like that, or if not, is there 3rd-party software that would solve this problem?