You are here: All Help Topics > Engagement Management > Users > Turning off Auto Close in the SQL Server
-- How Do I? --

Turning off Auto Close in the SQL Server

When you create a Data Store in a SQL Server, you must set the Auto Close property for the SQL database to False. This ensures that the database does not unexpectedly go offline if no one is connected to it.

  1. Launch Microsoft SQL Server Management Studio Express.
  2. In the Databases folder, locate the database that you created for the Data Store.
  3. Right-click the database folder and click Properties.
  4. In the Select a page panel, click Options.
  5. In the Automatic panel, click the drop-down beside Auto Close. Choose False.
  6. Click OK.

Related Topics