Event ID 17137

Check if in the Microsoft SQL Server for the Citavi database, the Auto_Close option is enabled. If so, the database is closed each time and its resources are only released once there are no more user connections accessing the database. When a new connection is established, the database restarts automatically. This can cause performance issues for databases that are accessed frequently and can also lead to database corruption.

If AUTO_CLOSE is disabled, the server keeps the database in an open and ready state regardless of user activity.

Microsoft recommends leaving the AUTO_CLOSE option set to OFF if a database is accessed frequently.

In the Microsoft SQL Server Management Studios you can change the AUTO_CLOSE setting. There are two ways to do this:

A. Run the following SQL command:


B. Make the change manually:

  1. Expand Databases.
  2. Right-click the Citavi database and select Properties.
  3. On the Database Properties window, switch to Options.
  4. Under More options add Automatic.
  5. Set the Auto_Close option to False, and then click OK.