Configuring Microsoft SQL Server 2014

From version 12.0 onwards the following parameters are automatically modified during the creation of the BCM database :

  • Recovery model = Simple
  • Parameterization = Forced
  • Read Committed Snapshot = True
  • Snapshot Isolation State = True

SQL_BASE_017.PNG

The database is now set up and configured for use with the BMC Client Management agent. However, before you can install the CM master on this computer, you need to ensure that the prerequisites that are listed in topic Database Prerequisites in the Windows installation section are fulfilled.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*