73.5 Configuring the Database Location Policy

The Database Location policy contains the location of the Inventory database. You can associate the Database Location policy with a container under which the Inventory Service object (Inventory Service_server_name) is located through using the Service Location Package or with an Inventory server through using the Server Package.

NOTE:If you configure the Service Location Package and the Server Package, the Server Package settings override the Service Location Package settings.

To associate the Database object with a container under which the Inventory Service object is located:

  1. In ConsoleOne, right-click the Service Location Package, then click Properties to display the Policies page.

  2. Select the check box under the Enabled column for the ZENworks Database policy.

  3. Click Properties to display the Inventory Management page.

  4. Browse to the DN of the Inventory Database object (Inventory database_server_name), then click OK.

    For a Sybase database, the database object is automatically created during the Workstation Inventory installation unless you are installing on a Windows server without eDirectory installed. To manually create the database object, see Manually Creating the Sybase Inventory Database Object.

    For an Oracle database, you must create the database object and configure the object. For more information, see Setting Up the Oracle Inventory Database.

    For an MS SQL database, you must configure the database object. For more information, see Setting Up the MS SQL Server 2000 or MS SQL Server 2005 Inventory Database.

  5. Click OK.

  6. Click the Associations tab, then click Add.

  7. Browse to select the container under which the Inventory Service object (Inventory Service_server_name) is located, then click OK.

  8. Click Apply, then click Close.

To associate the Database object with an Inventory server:

  1. In ConsoleOne, right-click the Server Package, then click Properties to display the Policies page.

  2. Select the check box under the Enabled column for the ZENworks Database policy.

  3. Click Properties to display the Inventory Management page.

  4. Browse to the DN of the Inventory Database object (Inventory database_server_name), then click OK.

    For a Sybase database, the database object is automatically created during the Workstation Inventory installation unless you are installing on a Windows server without eDirectory installed. To manually create the database object, see Manually Creating the Sybase Inventory Database Object.

    For an Oracle database, you must create the database object and configure the object. For more information, see Setting Up the Oracle Inventory Database.

    For an MS SQL database, you must configure the database object. For more information, see Setting Up the MS SQL Server 2000 or MS SQL Server 2005 Inventory Database.

  5. Click OK.

  6. Click the Associations tab, then click Add.

  7. Browse to select an NCP server object of an Inventory server, then click OK.

  8. Click Apply, then click Close.

NOTE:If you are modifying the Inventory policies or configuring the objects, always stop the Inventory services. Configure the policies and properties of the objects. Restart the Inventory services again. For more information on how to start the inventory service, see Section 73.1.5, Starting and Stopping the Inventory Service.