A recent experience provided some insight into SQL authentication. While assisting someone who was implementing the Zero Day Patch Workflow, they kept running into issues surrounding SQL authentication. They tried a variety of solutions.
Ultimately, the solution was to open SQL Management Studio, and give SYSADMIN privileges to the account serving the Application Pool in IIS. This resolved the issue for them.