Disabling the Auto Close feature in Ingest Database

This is only required for an upgrade of the Ingest database.

It is not required on a newly installed Ingest database since it will be set automatically during installation.

The Auto Close feature must be disabled to prevent the Ingest database from going offline automatically.

Open and log in to Microsoft SQL Server Management Studio.
Go to Databases and select ISDB.
Right-click on ISDB and select Properties.
The Database Properties - ISDB window opens.
Select the Options page.
In the Automatic section, select Auto Close and set the value to False.
Click OK. The Auto Close feature for Ingest Database is disabled.