Environment
Retain (4.x)
Retain Server (Linux and Windows)
Retain Worker (Linux, Windows)
Situation
Trying to create the Retain database on the MSSQL Server, getting the following error:
Error occurred configuring database: Failure to acquire Enterprise DB Connection
Resolution
Added SQL Server and Windows Authentication mode
For more details on how to do this see the following Microsoft Article: Choose an Authentication Mode
Additional Information
This article was originally published in the GWAVA knowledgebase as article ID 2851.