Setting up MS SQL Server with ODBC connection for installation

If SQL Server 2012/2014/2016/2017/2019 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.

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).

To create tablespaces for SQL Server

Creating the tablespaces for the BMC Client Management 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 BCM 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 BCM 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.

To create SQL server with ODBC (Optional)

To create an ODBC (Open Database Connectivity) connection (System DSN), proceed as follows:

  1. Open the window ODBC Data Source Administrator and select the System DSN tab.
  2. Click Add and select the SQL Server driver from the list, then click Next.
  3. In the window that opens enter the name for the data source (for example, bcmdb ), select the SQL Server to which to connect and click Next.
  4. Select the authentication type Windows or SQL Server and click Next.
  5. Select the previously created database (for example, bcmdb ), click Next and then Finish.
  6. In the window that appears click Test Data Source to verify the connection.
Was this page helpful? Yes No Submitting... Thank you