AppD Archive

APM SQL database agent error

CommunityUser
Splunk Employee
Splunk Employee

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.

0 Karma

Arun_Dasetty
Super Champion

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

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...