Chat now with support
Chat with Support

Change Auditor - For Advanced Users 7.1 - Technical Insight Guide

Change Auditor Services Change Auditor licensing processes Component Start-up Considerations Change Auditor network communications Coordinator internal tasks Registry Settings Change Auditor built-in fault tolerance Change Auditor protection Database Considerations Account exclusions best practices

Allow collation switch

Use the following registry setting to allow an upgrade to proceed even if it detects a different collation between the two databases. When this is set to 0 (default), you will receive an error indicating that the server collation is different and the upgrade process will stop.

Location

Registry

Path

HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditor\Coordinator

Value Name

AllowCollationSwitch

Value Type

DWORD

Default

0 - Upon coordinator start, do not allow the detection of a collation switch to proceed.

Value

0 - Upon coordinator start, do not allow the detection of a collation switch to proceed.

1 - Upon coordinator start, allow the detection of a collation switch to proceed.

Report zip limit

Use the following registry setting to specify the maximum number of bytes that can be included in a report zip file.

Location

Registry

Path

HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditor\Coordinator

Value Name

Report Zip Limit

Value Type

DWORD

Default

1024

Value

Report zip limit in bytes

SQL command timeout

Use the following registry setting to specify the maximum amount of time (in seconds) to allocate for executing a SQL command.

Location

Registry

Path

HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditor

Value Name

SQLTimeout

Value Type

DWORD

Default

30 seconds

Value

Maximum time in seconds for SQL command to execute.

Note

This value is overridden by some SQL commands, which are known to be long-running.

Enable ChangeAuditor Agent service to start with the Microsoft security update (KB2264107)

In 2010, Microsoft introduced a security update (KB2264107) to disallow the loading of 'unsafe' DLLs. The update sets the CWDIllegalInDllSearch registry entry to 0xFFFFFFFF under KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager.

This computer-wide setting will not allow the Change Auditor agent service (NPSrvHost.exe) to start.

Location

Registry

Path

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Image File Execution Options

Value Name

CWDIllegalInDllSearch

Value Type

DWORD

Default

Not present. Change Auditor Agent service will fail to start if the computer-wide setting is present.

Value

1 – Overrides the computer-wide setting for Change Auditor Agent service, it will be allowed to start.

Related Documents