Boot Order for MSSQL with CTE for Windows

Prerequisite

Setting the Proper Boot Order for SQL Server

CipherTrust Transparent Encryption must always boot up prior to Microsoft SQL starting. If MSSQL starts prior to CTE starting, it does not function properly. You can set this as a dependency in the Windows services. To set this dependency:

1. Open the command prompt and run it as an Administrator.

2. Modify the value of the service entry, type:

   sc config MSSQLSERVER depend=secfsd/vmd
   

To validate the dependency:

1. Open the Services.

2. Navigate to MSSQLSERVER service.

3. Click Properties > Dependencies. Under dependencies, it lists the two CTE services on which MSSQLSERVER is dependent.