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
- Select the Authentication Mode that you prefer to use.
- 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.