SQL Server 2008 2012 2014 prerequisites

If SQL Server 2008/2012/2014 is already installed as a database engine, you need to execute the following tasks before installing the master:

• Ensure that the SQL Server Express and the SQL Server Browser are exempted by the firewall on the server. This is done by adding sqlservr.exe and sqlbrowser.exe as exceptions in the Windows firewall.
• You might need to completely reboot the server after making these changes; starting and stopping the SQL Server Express and SQL Server Browser software might not be sufficient.

In addition the following operations must be executed:

Defining case sensitivity for SQL

SQL Server 2008/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 .

Creating a database on SQL Server

Creating a database for the 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 CM master installation in the Agent Configuration dialog box (this applies to Windows platforms only).

Creating tablespaces for SQL Server

Creating the tablespaces for the CM database in advance is optional. You can either create them directly during the installation of the master server or you can manually create them in advance and then provide the required information during installation. Creating the tablespaces is done through the execution of a script delivered with the Client Management installation archive in the support/database directory. Proceed as follows:

1. Go to the SQL Server to create a directory in which the tablespaces are to be installed (for example, Microsoft SQL Server/MSSQL/Data/ bcmdb ).
2. Open the SQL Query Analyzer and select the device on which the Client Management - database is located (for example, local , if it is on the local device).
3. Open the file Support/Database/Create_TS.sqlserver.sql of the Client Management installation archive in the SQL Query Analyzer window.
4. In the script, replace the placeholder &2 with the name of the Client Management - database (for example, bcmdb ), and &1 with the path to the tablespaces subdirectory created under step 1 (for example, Microsoft SQL Server/MSSQL/Data/ bcmdb ).
5. Verify that the script works correctly by clicking Parse Query . If the script works, execute it by clicking Execute Query .