Loading...

Knowledge Center


Changes made to an existing policy in ePO do not take affect on client computers
Technical Articles ID:  KB52512
Last Modified:  11/14/2012
Rated:


Environment

McAfee ePolicy Orchestrator 4.5 (Patch 1 and earlier)

Microsoft SQL Server 2000
Microsoft SQL Server 2005
 

Problem

Changes made to an existing policy do not take affect on the client computer.  Policy changes will be applied on the client computer if the policy is duplicated or a new policy is created. No policy enforcement errors displayed in the Agent_<computername>.log file or other default log files.

System Change

The SQL server setting for allowing triggers to fire others (nested triggers) is disabled.

Solution

This issue is resolved in ePolicy Orchestrator 4.5 Patch 3, which is available from the McAfee Downloads site at: http://mcafee.com/us/downloads/downloads.aspx. For instructions on how to download patches, see KB56057.
 
To review the Release Notes for this patch, see PD22678. For the addendum to the Release Notes, see KB69314.
 
Patches are cumulative. Therefore, McAfee recommends that you install the latest one.
 

Workaround 1

Enable nested triggers in the SQL server settings:
 
Microsoft SQL 2000:
  1. Open Microsoft SQL 2000 Enterprise Manager.
  2. Right-click on the server name and click Properties.
  3. Click the Server Settings tab and select Allow triggers to be fired which fire other triggers (nested triggers) under Server behavior.
  4. Click OK.
Microsoft SQL 2005:
  1. Open Microsoft SQL 2005 Management Studio.
  2. Right-click on the server name and click Properties.
  3. Click the Advanced entry and select Allow Triggers to Fire Others to True from the drop-down list.
  4. Click OK.

Workaround 2

Migrate the database to a different SQL server. For instructions, see KB58843.

Previous Document ID

615258

Rate this document

Did this article resolve your issue?

Please provide any comments below

Glossary of Technical Terms


Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.
United States - English
© 2003-2013 McAfee, Inc.