To define case sensitivity for SQL

SQL Server 2012/2014 is case insensitive. You can make it case sensitive by modifying the Collation Name parameter which is located in the Maintenance zone of the Database Properties dialog box. In this list box select the regional language corresponding to your operating system (CI = case insensitive, CS = case sensitive). To apply this value, the parameter must be set either during the installation of SQL Server or when creating the bcmdb database. It cannot be modified afterwards. If the database is set to case sensitive you must pay attention to the spelling when creating queries or when using the search tool in Client Management.

To create a database on SQL Server

Creating a database for the BMC Client Management in advance is optional. You can either create it directly during the master server installation or you can manually create it in advance and then provide the required information at the installation. You can accept the default database name ( bcmdb ) or create a new name. The name is requested during the BMC Client Management master installation in the Agent Configuration dialog box (this applies to Windows platforms only).