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-2676: DirectAudit Store Database cannot connect: "You do not have permission to connect to the SQL server"

Centrify DirectAudit ,  

12 April,16 at 11:47 AM

Applies to: Centrify DirectAudit version 2.x and above

Question:

When 'dainfo --diag' is executed as root, the following error is noticed:

Dad's current state:  The agent is not connected to a Collector
Dad's current Installation: not configured
Error while finding Collectors and verifying connectivity: Unable to find any service information in Active Directory: No more

On the Windows machine running Collector, in the Centrify Collector ControlPanel, under 'Current Status', it shows:
 
  "The Audit Store Database is not connected"
  "You do not have permission to connect to the SQL server"

Why does this message show? 









































Answer:
 

Please check the following:

 

1. On the Windows machine where SQL server is setup, click Start -> Run -> 'services.msc' and confirm that the Collector service (DirectAudit 2012 Collector) is running under the Local System account.

 

2. On the DB server, check that there is a login for collector's machine account (it should look something like MACHINENAME$) and login should be enabled.

 

3. On the DB server, check that the above specified login account should be a member of the "Collector" database role on the Audit Store database.

 

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

 

 

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

Related Articles

 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-6056: How to report the group policy settings that are in effect for the local computer? 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-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit 3.x installation from one database server to another articleKB-5944: Auditor Console/Audit Analyzer cannot open queries with error "Audit Server does not have permission to connect to SQL server" articleKB-3394: Is it possible to purge audit sessions older than 'x' number of days articleKB-4602: Pre-requisite SQL server and database permissions for users