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-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit 3.x installation from one database server to another

Centrify DirectAudit ,  

12 May,16 at 10:55 AM

Applies to: Centrify DirectAudit 3.0.x

Question:
How does one migrate databases associated with a Centrify DirectManage Audit 3.x installation from one SQL database server to another?

Answer:
Please check the attached document which has the step by step process to migrate databases associated with a Centrify DirectManage Audit 3.x installation from one database server to another.


At a high level, the steps are:

  1. Stop all the collectors.
     
  2. Take backup of existing databases (optional but recommended)
     
  3. Detach the existing databases and attach them to the new database server.
     
  4. Ensure that CLR integration is enabled on the new database server.
     
  5. Restore the TRUSTWORTHY flag.
     
  6. Modify the newly attached Audit Server database.
     
  7. Restoring connection between Audit Server database and Audit Store database.
     
  8. Update the database entries in Active Directory.
     
  9. Start all the collectors.


Also, verify if 'sa' is the owner.  If 'sa' is not the owner of the database, you can run the following query command to set 'sa' account as the owner:

sp_changedbowner [sa]


User-added image
 

Keywords: migrate SQL database changedbowner sa

Note:
Once the above steps are completed, do below steps on the SQL database server:

A. Start > All Programs > Microsoft SQL Server 200x > Configuration Tools > SQL Server Configuration Manager. 

Expand SQL Server 200x Network Configuration > double click Protocols for DIRECTAUDIT > Please make sure TCP/IP is Enabled 

B. Click Start > Administrative Tools > Service, right-click on SQL Server (DIRECTAUDIT) to start/restart the server. 

C. Check Trusted Collectors is correctly configured in Audit Store and any Allowed incoming Collectors in the database. 

D. The collector server and the database server should be part of the same AD forest. 

E. See if the AD domain name matches the issue described in: 

KB-2516: Centrify DirectAudit fails to resolve the Fully Qualified Domain Name for the SQL server

Attachments:

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