APM SQL database agent error

[CommunityUser]

got the sql db agent installed and configured. It appears to be active (connected to the controller and reporting on the db server), but in the events I keep seeing "(Re)initialize the DB collector" followed by "The user does not have permission to perform this action" with a severity of Critical, and no db details are returned. The Details tab shows:

com.microsoft.sqlserver.jdbc.SQLServerException: The user does not have permission to perform this action.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
 at com.singularity.ee.agent.dbagent.collector.db.relational.mssql.AMSSqlCollectorDelegate.collectStatusVariables(AMSSqlCollectorDelegate.java:219)
 at com.singularity.ee.agent.dbagent.collector.db.relational.mssql.AMSSqlCollectorDelegate.collectMetrics(AMSSqlCollectorDelegate.java:212)
 at com.singularity.ee.agent.dbagent.collector.db.relational.mssql.MSSql2008CollectorDelegate.collectMetrics(MSSql2008CollectorDelegate.java:130)
 at com.singularity.ee.agent.dbagent.collector.db.ADBCollectorDelegate.collect(ADBCollectorDelegate.java:97)
 at com.singularity.ee.agent.dbagent.collector.db.ADBCollector.run(ADBCollector.java:136)
 at com.singularity.ee.util.javaspecific.scheduler.AgentScheduledExecutorServiceImpl$SafeRunnable.run(AgentScheduledExecutorServiceImpl.java:107)
 at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
 at com.singularity.ee.util.javaspecific.scheduler.ADFutureTask$Sync.innerRunAndReset(ADFutureTask.java:335)
 at com.singularity.ee.util.javaspecific.scheduler.ADFutureTask.runAndReset(ADFutureTask.java:152)
 at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.access$101(ADScheduledThreadPoolExecutor.java:119)
 at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.runPeriodic(ADScheduledThreadPoolExecutor.java:206)
 at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.run(ADScheduledThreadPoolExecutor.java:236)
 at com.singularity.ee.util.javaspecific.scheduler.ADThreadPoolExecutor$Worker.runTask(ADThreadPoolExecutor.java:694)
 at com.singularity.ee.util.javaspecific.scheduler.ADThreadPoolExecutor$Worker.run(ADThreadPoolExecutor.java:726)
 at java.lang.Thread.run(Unknown Source)

What is the action and what is the permission required?

the account used has db_owner, db_securityadmin, db_datawriter, db_datareader and db_accessadmin to the database.

This repeats every minute.

[Arun_Dasetty]

Hi ,

Can you please validate the perrmissions as per doc link and see how it geos with re-save of collector and restart of db agent and other dependent services?

https://docs.appdynamics.com/display/PRO40/Configure+WMI+Permissions+and+Security