Centrify

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-6010: Add Audit Store Database wizard fails with owner sid error

Auditing and Monitoring Service ,  

18 December,15 at 11:50 PM

Applies to: Centrify Direct Audit Audit Manager

Problem:
Add Audit Store Database wizard of Audit Manager fails with an error indicating that the database owner SID recorded in the master database differs from the database owner SID recorded in the newly created database.

Error in Wizard:
[2015-12-11 11:45:44.961 +0200] mmc.exe[59372,5] Verbose: WorkerThread`2.RunOuter: Unexpected exception from worker thread 'Commit the add Audit Store database wizard thread'
[2015-12-11 11:45:44.961 +0200] mmc.exe[59372,5] Verbose: WorkerThread`2.RunOuter: Centrify.DirectAudit.Common.Logic.UnexpectedException: A database operation error occurred. Please contact your administrator to make sure the remote database is accessible and working properly. ---> System.Data.SqlClient.SqlException: The database owner SID recorded in the master database differs from the database owner SID recorded in database 'AuditStore-2015-12-11-new'. You should correct this situation by resetting the owner of database 'AuditStore-2015-12-11-new' using the ALTER AUTHORIZATION statement.

Root cause - You may see this error if the user who is rotating the Audit Store database is a member of db_owner role of model database. Since the user principals of model database are copied whenever a new database is created, it results into mismatched owner SID records.

Workaround - Remove this user from the role members list of db_owner database role of model database and retry.

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

Related Articles

 articleKB-7547: Add Audit Store database wizard fails with following error, "A constraint violation occurred" articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role? articleKB-6041: How to show current license type in use by adclient? articleKB-6040: How to change the license type in use after adclient successful joined to the AD? articleKB-6038: How to specify the license type to use when joining the server to AD using adjoin? articleKB-6056: How to report the group policy settings that are in effect for the local computer? articleKB-7555: Unable to login as root after upgrade to Centrify Suite 2016 (CDC 5.3.0) articleKB-3925: How to add Centrify parameter to a group policy articleKB-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit 3.x installation from one database server to another