Configuring Microsoft SQL Server database server

A qualified Microsoft SQL Server database administrator needs to perform the following configurations to make your SQL Server database server work with Content Manager:

  • Install the Microsoft SQL Server database server with default options, with the following exception: SQL and Windows authentication must be enabled.
  • Set the database to 'autogrowth'. Ensure that the database is set to grow in fixed-size increments of about 50 MB.

    Setting autogrowth to a percentage may result in timeouts on large database. For example, a 10 GB database with autogrowth set to 10% must allocate and initialize 1 GB, and execute the initializing statement, all within 30 seconds.

  • Use TCP/IP for best performance of distributed transactions. Configure this setting in the Microsoft SQL Server Client Network Utility.
  • Ensure that the Microsoft SQL Server instance collation is case-insensitive.