Using CloudNine LAW > Administrating CloudNine™ LAW > Database Installation and Configuration

CloudNine™ LAW requires separate database software to be installed and configured properly. Standard Microsoft SQL Server is recommended, but Express may be used in environments with small cases (Express has a limit of 10GB per database). See the System Requirements for more details on requirements for proper setup.

Other SQL Express limitations

•1GB maximum memory used by the database engine.

•10GB maximum database size

•1MB maximum buffer cache

•CPU the lesser of one (1) socket or four (4) cores (number of SQL user connections NOT limited)

If you believe that you are going to hit any of these limitations, then you should build your SQL server to work with a full SQL installation.

Some more limitations are listed here: Main Limitations of SQL Server Express Editions - SQLNetHub

Proper installation and configuration of SQL Server should be discussed with your SQL database administrator.

The following instructions provide sample values to use to setup a configuration of SQL Server (Express) with Tools. Use this as a starting point when discussing a production oriented SQL Server configuration with your SQL database administrator.

Installation Tasks

•Instance name: can use default -- for example, SQLEXPRESS

•Features: Database Engine Services and Management Tools - Basic

•Account Name: NT AUTHORITY\ NETWORK SERVICE

•Password = leave blank (default)

•Database Engine Configuration dialog box: Mixed Mode (SQL Server authentication and Windows authentication)

•SQL Administrator password: select a password of your choice.

•User accounts: Add Current User. Or add at least one Windows login or domain user account.