Creating an MS SQL server configuration

You can create a server installation configuration to use an MS SQL database. You must install the database, either locally or remotely, and create a database instance before you install the IBM® BigFix® Remote Control server.

About this task

To create an MS SQL server configuration task, complete the following steps:

Procedure

  1. Select the relevant operating system.
  2. Enter the installation directory for the IBM BigFix Remote Control server to be installed to or accept the default that is given.
  3. Select the relevant MS SQL version and enter the relevant database parameters.
    Database server address
    The IP address or host name of your database server.
    Note: 127.0.0.1 can be used when MS SQL is installed locally on a Windows™ system only.
    Port on which to connect to the database
    Port on which MS SQL is installed.
    Name of the Database to use
    Specify the name for the database to be used with the IBM BigFix Remote Control server or accept the default that is given.
    Database Administrator Userid
    Specify the Administrator user ID used for logging on to the database. The user ID must have admin access to the database.
    Database Administrator Password
    Specify the Administrator password for connecting to the database.
    Path to the JDBC drivers
    Specify the path to the MS JDBC java files. The sqljdbc4.jar file must be used. The following version of driver can be downloaded from Microsoft. Microsoft JDBC Driver 4.0 for SQL Server - sqljdbc_4.0.2206.100_enu.exe.
    If Local, create the database
    If MS SQL is installed locally, you can select to create a blank database during the installation.
    If Local, drop an existing database
    If MS SQL is installed locally, you can select to drop the database and create a new one. Do not select drop the database if you are using a remote database.
    New database location (the directory must exist)
    Specify the database installation path. If the installation is local and you select to create the database the Admin user must have appropriate authority to do so.
    Linux® systems.
    Specify a directory that the admin User ID has read and write permissions for.
    Windows systems.
    Specify an existing directory.
  4. Enter the relevant server installation parameters as in step 4
  5. Save your server installation task by following step 5