This article assumes that the steps in the article "Configuring the Flow Bootstrap Service" was followed, but in some scenarios the Windows account used to startup the Flow Bootstrap Service cannot be given access to the MSSQL server.
Some use cases would be if you are using a Cloud hosted MSSQL server, a Docker MSSQL image, or a remote deployed solution between a DMZ.
In these use cases, we can configure the Flow Bootstrap Service to use SQL authentication instead.
The Flow Config Tool Systems Menu.
By default, the Flow Bootstrap Service will try and use the service logon credentials to try and access the Flow Database. One can change this from in the Flow Configuration Tool.
Access the system properties by navigating to the "SYSTEM\Properties" menu item.
Flow Bootstrap “Log On” Username and Password
Under the Systems Properties, there will be "Username" and "Password" fields to populate with the relevant MSSQL credentials. By default these properties are blank.
Populate these properties with the correct MSSQL credentials and deploy the Flow Platform from the deployment tab.
If the Platform was already deployed, an undeploy/deploy might need to be preformed to make sure the deployment process use the newly entered credentials.