Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-10203 How to rename DirectAudit Database?

Centrify DirectAudit ,  

24 April,18 at 08:14 AM

Question:
How to rename DirectAudit Database?

Answer:

To rename the Management database and the Audit Store database(s), it is essentially performing database migration without actually migrating the databases to a different server. The details steps is included in attached PDF file and see more details in :
KB-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit 3.x installation from one database server to another.

Summary of steps to rename Management database and Audit Store database(s),

1. Rename all the databases using SQL Management studio (might need to take the DBs offline before you can rename them).

2. Update the rows in dbo.ManagementDatabase and dbo.AuditStoreDatabase tables using SQL Management studio (value for the column "Database" needs to be renamed).

3. Using ADSIEdit.msc, update the DA installation SCP (specific instructions are in the PDF attached to this KB).

4. Reconnect to the installation using Audit Manager console and re-sync the publication information.

Note:
Renaming Both the Management database and the Audit Store database(s) with above steps is not an easy process to perform which involved Data amendment.
Please reconsider your decision to  rename the AuditStore Database before perform above steps.

Attachments:

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.