What is the recommended status for the Autoclose setting for the Orchestrate SQL database, within SQL management studio?
The recommended setting is False, when you select the following:
Right-click relevant Orchestrate database and select properties
select options
Select False within the AutoClose field.
This prevents the database from shutting down, after all resources that reference this database are freed.