What is the version of EPO/vROps? What particular service is in question?
I would rather check that connection from EPO to vROps is OK - agent.log could be helpful here.
we are running Version 6.4. Also the EPO Agent is the latest Version.
I have checked the Log files and found on the related warnings the following entrys.
[MsSQLMeasurementPlugin] Unable to connect to the DB 'MSSQL$TMSM', review the sqlserver_name/instance/testdbcon options. Command execution terminated with erronous Exit Value: master tempdb model msdb db_TMSM
(5 rows affected)
org.hyperic.hq.product.PluginException: Command execution terminated with erronous Exit Value: master tempdb model msdb db_TMSM
(5 rows affected)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Do you have any idea whats going wrong?
1. Regarding error message - mostly it's due to the account permission - EPO use service account (local system by default) to impersonate on the SQL instance. Check that instance in question either have System added to the Security--Logins or use the same account which is used to start SQL to start EPO agent.
2. Regarding service down - epo will provide service status once in 5 minutes. check windows event log if that is any errors indicating that SQL service for one of the instance might be restarted. if not the case, after correcting problem with the credentials, check the behavior.
i think it is not an account or permission issue. Because the error message do not appear the whole day. And if i understand it right, than the end point agent try to resolve the content on the vm every 5 minutes.
So if there is a permission issue, the error message should pop up every 5 minutes. Or am i wrong?
What i saw is, that the collection takes more than the default 5000 ms. I try to change the agent.properties