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  >

KB-8153: AuditStore DB is offline if Management Database logon account is a virtual account

Auditing and Monitoring Service ,  

2 February,17 at 12:24 AM

Applies to: Direct Audit Suite 2016.1 (5.3.1) on all supported platforms

AuditStore Database goes offline if the Management Database logon account is a virtual account.

The permissions assigned to an outgoing account (DOMAIN\SQL$) are not sufficient enough when the Management Database is hosted on a SQL server whose service account is a virtual account (NT SERVICE\MSSQLSERVER) and Audit Store Database is hosted on another SQL instance on the same server and that server is running under domain admin account. 

Create a login for NT SERVICE\MSSQLSERVER on Audit Store Database and add this login to be a member of 'db_owner' role of the Audit Store database. Once done, the Audit Store DB will come back online. If db_owner permission cannot be assigned, the same result can be achieved by adding this login to be a member of 'db_securityadmin' role.

All other accounts (Network Service, Local System, domain user etc.), work as expected without the need of granting the additional role.

Will be fixed in a future release.