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"

Auditing and Monitoring Service ,  

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.

 

 

Related Articles

 articleKB-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit installation from one database server to another articleKB-4879: DirectAudit Agent online but offline store is not despooling after improper shutdown articleKB-4835: Procedure for properly deleting the offline store from a DirectAudit agent articleKB-2575: You cannot connect to the SQL Server. Please make sure the SQL Server is running and allows remote connection. articleKB-16338: The DirectAudit collector is not able to connect to the Auditstore database after an upgrade articleKB-8409: DirectAudit Agent online but offline store is not despooling articleKB-4602: Pre-requisite SQL server and database permissions for users articleKB-4546: What is the purpose of outgoing account used in DirectAudit articleKB-10203 How to rename DirectAudit Database?