Forum Discussion
SQL Server on Windows 10 or 11 with data on a secondary drive with bitlocker enabled
Hello, On a Windows pro, 10 or 11 (both tested), with SQL Server 2019 (developer edition) installed with its program files in the system drive, C:, but its data files in a data drive D:, both cip...
Have you tried delayed start option in sql server services?
- Yes I have tried that. Maybe rarely it helps, meaning sometime I do not have to restart it manually, but most of the time it is just the same. And so, I am not even sure that is a change that some very rare times makes a difference.
- You can try couple of other options
1) Increase registry stratup delay for the sql services
2) use the same account to run sql services and enable bitlocker.- Thanks,
Unfortunately the SQL Server service won't start with my personal account. It has local admin rights, but that is an AAD account (no on premise AD), which is maybe the issue for SQL Server.
With the two minutes default delay for delayed auto-start, I am quite confident I am already logged-in when it starts. So, I do not expect increasing the delay will do. (My laptop power button is also a fingerprints reader and powering-up with a known finger causes it to automatically log-in once started.)
Still I have added this:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER]
"AutoStartDelay"=dword:000493e0
I will see if it helps
