Management Data Warehouse - Data Collector -- dxexec errors
Posted on 2014-04-28
I have been putting together a MDW for a little while now, in SQL Server v2012, to perform the collection and upload of all sorts of server and database statistics. I have actually posted a couple inquiries up here already, but I just deleted them, because I never received any responses.
Last round, I'm going to try one more time. I would greatly appreciate any EE input.
Short story - The MDW is on a v2012 instance, I collect data from both v2012 and v2005 instances. The v2005 instances are targeted (successfully) with custom collectors that I have created on the MDW, which target the v2005 instances via linked server. The v2012 instances use the three default system collectors, and one custom collector:
I have resolved all of my errors and problems except for one.
The system collectors for Server Activity and Query Statistics both fail with this error:
dcexec: Error: Internal error at Main (Reason: The system cannot find the file specified).
Here I am referring to the SQL Server Agent jobs that were created when the data collector was enabled, that is used to 'collect' the data. It is the two collector Agent jobs that are failing with the above error.
Please let me know if there is any other detail that I can provide, that will help an Expert to help me.